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

kirkostas
kirkostas Member Posts: 127
edited 2008-07-16 in NAV/Navision Classic Client
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™

Comments

  • kirkostas
    kirkostas Member Posts: 127
    I found it forget it.
    It is with SETFILTER by using |

    I am really sorry.
    kirkostas™
  • Sandeep_Prajapati
    Sandeep_Prajapati Member Posts: 151
    http://www.mibuso.com/forum/viewtopic.p ... ion+filter
    Sandeep Prajapati
    Technical Consultant, MS Dynamics NAV
  • anand-gupta
    anand-gupta Member Posts: 2
    You can do this use of | sign with SETFILTER---
    SETFILTER("Document Type",'%1|%2',"Document Type"::Payment,"Document Type"::Invoice)
    Anand.......
  • Sandeep_Prajapati
    Sandeep_Prajapati Member Posts: 151
    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')
    Sandeep Prajapati
    Technical Consultant, MS Dynamics NAV

Categories