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

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

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?

 

 

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.

View reply

10 replies

Eric_D_Miller
Eric_D_MillerAuthor
Level 5
December 10, 2024

More details here:

 

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

Translate
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.

Translate
    Eric_D_Miller
    Eric_D_MillerAuthor
    Level 5
    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.

    Translate
    Terms & ConditionsAccessibility statement

    Loading footer...