How can I have a "Where" clause with "OR&quot

kirkostas

I want to filter my Customer table in 2 fields but with "OR" operator.
Bring Customers where field1 = 'xxxx' or field2 = 'xxxx'.
How can I do that in Navision?

kirkostas

I found it forget it.
It is with SETFILTER by using |

I am really sorry.

Sandeep_Prajapati

http://www.mibuso.com/forum/viewtopic.p ... ion+filter

anand-gupta

You can do this use of | sign with SETFILTER---
SETFILTER("Document Type",'%1|%2',"Document Type"::Payment,"Document Type"::Invoice)

Sandeep_Prajapati

You can do this use of | sign with SETFILTER---
SETFILTER("Document Type",'%1|%2',"Document Type"::Payment,"Document Type"::Invoice)

No, :!:
This is for (Field1 = 'xxxx' OR Field1 = 'yyyy') but the requirement is
(Field1 = 'xxxx' OR Field2 = 'yyyy')