Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

How do you filter using a Contains or Equals modifier on a text field and search for more than one value? Ex. Field contains or equals "Clearance, Assurance, AHI". I want it to return results when one of the 3 search matches are found.

Avatar

Level 2
 
Topics

Topics help categorize Community content and increase your ability to discover relevant content.

2 Replies

Avatar

Level 10

If you want it to just match one of the three words, you should be able to do OR statements in the filter. Just remember you have to do the other filters as well for each OR.

0690z000009ClHcAAK.png

The one thing I haven't figured out is if you want something that matches all three words. If anyone knows how to do that, let me know. 😉

Avatar

Level 2

Thanks. I was hoping there would be an easier way as I have to create 11 OR statements with much of the same logic. I appreciate your response!