Except '<>' in filters

Dynamics 365 Business Central/NAV User Forum
1

hi,

i want to do the following filter

Filter on No. <> item1 and item2

2

Did you try
Item.SETFILTER(“No.”,’<>%1 & <>%2’,item1,item2);

3

it works like that , how can i do the following:

REPEAT

IF SalesInvoice not valid THEN

IF RejectedDocNO = ‘’ then

RejectedDocNO := SH.“No.”

ELSE

RejectedDocNO += ‘|’ + SH.“No.”

UNTIL SH.NEXT = 0

SETFILTER(“Document No.”,’<>%1’, RejectedDocNO );

4

Where did you write this code?

5

in a codeunit, the filter will be like the following:

SETFILTER(“Document No.”,’<>%1’,item1|item2|item3|item4,…)

6

Did you try to print the RejectedDocNO using a message before SETFILTER?

7

RejectedDocNO = item1|item2|item3|item4|…

8

Did you try with

SETFILTER(“Document No.”,RejectedDocNO );

9

i want to filter except the rejecteddoc [ <> RejectedDocNO ]

10

I never used it with <>…

why dont you modify your login

REPEAT

IF SalesInvoicevalid THEN

IF AcceptedDocNO = ‘’ then

AcceptedDocNO := SH.“No.”

ELSE

AcceptedDocNO += ‘|’ + SH.“No.”

UNTIL SH.NEXT = 0

SETFILTER(“Document No.”,AcceptedDocNO );