Skip to main content
Eric_D_Miller
Level 5
Dec 10, 2024 3:20 PM UTC
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?

 

 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
ChrisStephens
ChrisStephensAccepted solution
Community Advisor
Dec 10, 2024 9:58 PM UTC

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.

10 replies

Eric_D_Miller
Level 5
Dec 10, 2024 9:46 PM UTC

More details here:

 

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

Translate
ChrisStephens
Community Advisor
ChrisStephensCommunity AdvisorAccepted solution
Community Advisor
Dec 10, 2024 9:58 PM UTC

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
Level 5
Dec 11, 2024 2:19 PM UTC

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