Problem with SETFILTER

poppins

Hi everyone,

I am trying to use SETFILTER for multiple values of Item No. and I am not sure about the syntax to adopt:

I want to set a filter to consider only the items with the following numbers:1000, 1030, 1056 and 1999.

recItem.SETFILTER("No.", '%1&%2&%3&%4', '1000', '1030', '1056','1999');

Is it correct???

lvanvugt

recItem.SETFILTER("No.", '%1|%2|%3|%4', '1000', '1030', '1056','1999');

As you will never find a record that has Item No. equal (at the same time) to the values '1000', '1030', '1056', '1999'

poppins

Thanks

Chinmoy

recItem.SETFILTER("No.", '%1|%2|%3|%4', '1000', '1030', '1056','1999');

This should work, as '|' means OR not AND.