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.

  • December 10, 2024
  • 1 reply
  • 1345 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?

 

 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
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
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.

ChrisStephens
Community Advisor
ChrisStephensCommunity AdvisorAccepted solution
Community Advisor
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
    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.

    Terms & ConditionsAccessibility statement

    Loading footer...