Report filter with OR operator

Bor1980
Bor1980 Member Posts: 17
in NAV Three Tier
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

  • lubost
    lubost Member Posts: 633
    In code you have to decide (by IF statement) inside the customer loop to use or skip record.

Categories