Set Filter

elTorito

Hi,

i have a lot of items ...

if i set a Filter on the ItemNo. Field i get all the items that are init with the chars who i search. e.g.:

I Set Filter to ItemNo.: AR*

This get all the ItemNo with AR*

What must i do if i would list all the Items that are not init by AR*.

i have try

ItemNo <>AR*

But this doen't seem to work.

Have anybody a tip for me ?

In the Filter/Serach Doku and Book i can't find property for make this.

Thanks.

facade

Works in Navision 3.70 + SQL version but yes unfortunately not in native and previous versions.

Asallai

elTorito wrote:

Hi,

i have a lot of items ...

if i set a Filter on the ItemNo. Field i get all the items that are init with the chars who i search. e.g.:

I Set Filter to ItemNo.: AR*

This get all the ItemNo with AR*

What must i do if i would list all the Items that are not init by AR*.

i have try

ItemNo <>AR*

But this doen't seem to work.

Have anybody a tip for me ?

In the Filter/Serach Doku and Book i can't find property for make this.

Thanks.

Hello,

Try this:

rec.SETFILTER(Field,'<>%1','AR*');

:?

SteveO

SETFILTER(ItemNo, '<%1|>%2|%3', 'AR’,’AR*','');

Hasn't failed me yet...