Report filter with OR operator

Bor1980Bor1980 Member Posts: 17
Dear Mibuso members,

I want to build a report (or query) same like my sql query.
In my sql query (on customer table) I have a filter with an OR operator

Example:
WHERE (customer.[Deceased] = 1 OR customer.[Date Deceased] <> '1753-01-01 00:00:00.000')

How do I build this in a NAV report or query?

Thank you


Best Regards,
Rob


Dynamics NAV2016

Answers

  • lubostlubost Member Posts: 611
    In code you have to decide (by IF statement) inside the customer loop to use or skip record.
Sign In or Register to comment.