Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Filter issue with &&&&

Hi,
I have a trouble with filtering a table. Please see code below:

All Site[SiteCode] filters works properly, but not the Employee [DprtId] filter. This is what I see as the result:

Please help to understand what's wrong here. 

Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Thanks for turning me to the right track of thougts 🙂 Just needed to change && --> AND function and now it works as I expected. Posting screenshot to anyone can help in the future. 

     

4 Replies

  • az38's avatar
    az38
    Icon for Community Champion rankCommunity Champion
    6 years ago

    Hi Anonymous 

    First of all, your OR conditions should be in parenthesises like

    [DrtID] = 100 && ([SiteCode]="OD" || [SiteCode]="KV" || [SiteCode]="LV")

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      az38  Hi! I can't do like that because of RELATED function

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Thanks for turning me to the right track of thougts 🙂 Just needed to change && --> AND function and now it works as I expected. Posting screenshot to anyone can help in the future.