Is It Possible / How to use the 'OR' text operator in filters. | Community
Skip to main content
Eric_D_Miller
Eric_D_Miller
New Participant
December 10, 2024
Solved

Is It Possible / How to use the 'OR' text operator in filters.

  • December 10, 2024
  • 1 reply
  • 1341 views

Hello,

 

I am attempting to key on multiple values in one filter and wanted to know if you can use the 'OR' function in the text operator. See below screenshot for reference. Am I doing something wrong?

 

 

Best answer by ChrisStephens

How you have that written it won't work, no.

 

I usually make an array of those values, then do a "Not In (array)" comparison.

1 reply

Eric_D_Miller
Eric_D_MillerAuthor
New Participant
December 10, 2024

More details here:

 

In this screenshot you can see that my it passed the filter despite not matching the operator.

ChrisStephens
ChrisStephensAccepted solution
New Participant
December 10, 2024

How you have that written it won't work, no.

 

I usually make an array of those values, then do a "Not In (array)" comparison.

    Eric_D_Miller
    Eric_D_MillerAuthor
    New Participant
    December 11, 2024

    Hi Chris,

     

    Thank you for the reply.

    What is the best way to go about making an array of the values? Could you show me via screenshot the module(s) you use?

     

    Thank you in advance.

    Terms & ConditionsAccessibility statement

    Loading footer...