Filter

(0) Share

Report

Posted on by jsshivalik

3,051

I am using Sale Order & Line DataItem . In Line DataItem property i want to add in Table Filter that there should not be a particulat Item No say 'XYZ'.

*This post is locked for comments

All responses (3)

Answers (1)

Verified answer

Suresh Kulla 44,614 on at

Like (0)

Report

RE: Filter

If you don't want to consider then you need to use FILTER <> like below

WHERE(No.=FILTER(<>A32950))
jsshivalik 3,051 on at

Like (0)

Report

RE: Filter

Hi

I have written this . I want that this item no should not be considered .

WHERE(No.=CONST(A32950))

Thanks
Suggested answer

Suresh Kulla 44,614 on at

Like (0)

Report

RE: Filter

Using DataItemTableView Property on the DataItem and using the table filter apply the CONST filter for the No. and use the Item NO. Value.