Working with filters

Business Central/NAV Developers Forum
1

Hi. I have several records with the description starting with TH… Do I have a chance to filter them out? the usual Rec.SETFILTER(Description, ‘<>%1’, ‘TH*’) does not work

2

First of all, you should filter records using “Search Description” with current key on it (if field is in a table you use). I didn’t find a way to perform this filter but if you go through all records afterwards, you can check every record if Description field contains ‘RE’ (IF STRPOS(Description,‘RE’) = 1). -

3

I found a way! You can use filter like this: SETFILTER(Description,'..RD*|RF*..');

4

Could you tell me in human language what ‘…RD*|RF*…’ means?

5

quote:

Could you tell me in human language what ‘…RD*|RF*…’ means?

More educational, perhaps, in this case would be SETFILTER(Description,‘…@tg*|@ti*…’); thus avoiding Description starting with TH (haven’t tried it, but it seems plausible [^]).

6

quote:

Originally posted by ajhvdb
Could you tell me in human language what ‘…RD*|RF*…’ means?

It could be answer to topic if it looked like this: SETFILTER(Description,'..TG*|TI*..'); [:D]