SETFILTER using a String with integers

McMercy · 2008-06-27

Hello!

How do I have to code the following filter:

IF TableInput.FIND ('-') THEN BEGIN
REPEAT
strFilter := strFilter + Format( TableInput.TableID) + '|';
UNTIL TableInput.NEXT = 0;
END;

SETFILTER("Object ID",'%1',strFilter);

The Filter should filter by Objekt ID which is an integer, of course strFilter is a string with a list of integers linked with |. Navision refuses to do this, what is the correct synthax?

Thanks

garak · 2008-06-27

setfilter("Object ID", strFilter);

Note: with your loop, the variable strFilter ends with a | <- this you must eleminate.

Regards

DaveT · 2008-06-27

DaveT · 2008-06-27

garak wrote:

setfilter("Object ID", strFilter);

Note: with your loop, the variable strFilter ends with a | <- this you must eleminate.

Regards

Dam it - Beaten again #-o - you Germany are far too efficent

garak · 2008-06-27

sorry dave: the first problem is the way he use setfilter

the thierd parameter, the value, must have the same datatype like the field which is filtered. The filtered field is from type integer. But the value is text so the compiler would tell this.
To solved this, you can put your filterconsturct into the second parameter. Instead of

setfilter(YourFieldIsInteger,'%1|%2|%3',1,4,6);

you can also write

setfilter(YourFieldIsInteger,'1|4|6);

but not

setfilter(YourFieldIsInteger,'%1','1|4|6');

the second problem in this code is, see in the first post, that the variable strFilter ends with a | <- the last pipe must be eleminated

regards

garak · 2008-06-27

no comment ;-) :whistle:

DaveT · 2008-06-27

:oops: missed the setfilter problem - just like the compiler I stopped when I hit the first problem

David_Cox · 2008-06-29

Nearly There but as said the last pipe "|" is a problem, but the solution is simple.
1st problem there might be only one record, so we have to code for this.
2nd the Pipe "|" has to come before the the string, but not for the First Record, so we add a counter, and change the string based on its value.

J := 0;
IF TableInput.FIND ('-') THEN 
   REPEAT 
       j := j + 1;
       IF j := 1 THEN
          strFilter := Format( TableInput.TableID)
       ELSE
          strFilter := strFilter + '|' + Format( TableInput.TableID); 
   UNTIL TableInput.NEXT = 0;

Hope this helps!

David

andy76 · 2008-12-30

Hello,

is that possible to filter...constructing a string as the previous... but with <> (not equal ) from a list?

SETRANGE("Purch.Order Line No.", '<>%1', myString) ?
with my String = 'A|B|C...'

Or which is the right syntax?

myString = '<>A|<>B|<>C ...'

Thank you

kine · 2008-12-30

You need to use AND between each part. it means '<>A&<>B&<>C' else it will be true in all cases...

Belias · 2008-12-30

kine wrote:

You need to use AND between each part. it means '<>A&<>B&<>C' else it will be true in all cases...

unless a=b=c

SETFILTER using a String with integers

Comments

Categories