Using OR operator in "Do a search for"

How can use the OR operator while setting up a condition in Do a Search for.

My table has the following columns - Name, Type (about a dozen possibilities), Email, Phone

I want to show all those rows, where Type = Credit or Type = Failed.

Thanks,

2 Options

Option 1:

Search For Thing (filter: Type = Credit) MERGED WITH Search for Thing (filter: Type = Failed)

Option 2:

Do an advanced search where the constraint is “This thing’s Type is Credit OR this thing’s Type is Failed”

Advanced searches usually take longer and are less efficient. I recommend option 1 but try both just in case.

Hope this helps,
Daniel

8 Likes

This topic was automatically closed after 70 days. New replies are no longer allowed.