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

[Eric_D_Miller]

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?

[Eric_D_Miller]

More details here:

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

[ChrisStephens · Accepted solution]

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]

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.

[ChrisStephens]

Sure. When you pick your "Does not contain", make sure you go to the array section of the filtering options.

[Eric_D_Miller]

Chris,

When adding in the Text Operators, (where you have 'value1') can I include each value in the "Array: Does Not Contain"?

Are there any modules I need to run before the filter to ensure I have the right data coming in? Right now, I am just reading the records I need to filter on before the filter.

I appreciate the help, I am still learning quite a but about Fusion!

[ChrisStephens]

No worries!

Just replace each entry where I have "valueX" with 1 of your values you are checking for, and the only module you need to run before your filter is wherever the data you're filtering against is coming from. You can keep adding however many entries you need, just separate each entry with a semicolon.

[Eric_D_Miller]

I have this built so with the values I need to filter for.

What do I add into the Array Operators? Is it as simple as 'value1 ; value2 ; value3; etc.' ?

Thanks again.

[ChrisStephens]

Your parameter from earlier, this one 

[Eric_D_Miller]

You rock Chris! That got it working.

Thanks for the help and for being so kind! 

[ChrisStephens]

All good, glad you got it working. Have a good one!