How to use SETFILTER with OR logical operation.

(0) Share

Report

Posted on by Krish Roy

I want to use filter on two fields of the same table with one value.

There are two columns named as posting date and document date and let's suppose I want to get rows having either posting date =TODAY OR document date =Today.

When I use SETFILTER two times it gives me rows having posting date and document date=TODAY.

BUT I want to get all rows whose posting date is TODAY may be document date is different and all rows whose Document date is TODAY may be posting date has different value.

I hope its enough to understand the scenario.

May be there is no possibilities to use OR with SETFILTER but if you Know another way to solve it then feel free to share with me I'll really appreciate that.

Thank you.

*This post is locked for comments

All responses (2)

Answers (0)

Suggested answer

Suresh Kulla 46,792 on at

Like (0)

Report

RE: How to use SETFILTER with OR logical operation.

Unfortunately you cannot do that with one single fitler, you need to filter on one field get the records and store in temporary or mark them, then again reset and apply the next filter and insert those into temporary/mark.
Suggested answer

HoangNam 315 on at

Like (0)

Report

RE: How to use SETFILTER with OR logical operation.

You can use FILTERGROUP(-1).

You can reference Page 658 Approval Entries which use MarkAllWhereUserisApproverOrSender method of Table 454 Approval Entry.