Report filter with OR operator

Bor1980

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

lubost

In code you have to decide (by IF statement) inside the customer loop to use or skip record.