Search Filter with OR logic

Is is possible to do a simple filter like this?

where col1 = 'SOMEVAL' or col2 = 'SOMEVAL'

3replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • For now you can have such "OR" conditions only through the "if" function in a formula. So you can have a function that says

    if(col1 = 'SOMEVAL' or col2 = 'SOMEVAL'col1 = 'SOMEVAL' or col2 = 'SOMEVAL') then true else false

     

    and then filter only for true values of this formula.

    Reply Like
  • Siva Singaram thank you that is what I suspected (it is not part of normal search line).

     

    That said, how could the clause/predicate/statement be written to compare col1 and col2 against a pinboard parameter?

     

    what would be the syntax?

    Reply Like
  • We've some exciting new features to enable this kind of parameters across pinboards and the whole app in our product roadmap.

    Reply Like
Like1 Follow
  • Status Answered
  • 1 Likes
  • 8 mths agoLast active
  • 3Replies
  • 27Views
  • 2 Following