Is this an **and** or **or** function?

[darren.james7518]

When doing a “Search for”, will the following search for RESI DOOR and FRENCH DOOR? I was confused if it an and or or function.

[mikeloc]

Hi there, @darren.james7518… when you add constraints to the same search, those constraints are joined with and, meaning all of the constraints must be true in order for an item to be returned in the search.

Best…
Mike

[darren.james7518]

Thanks Mike … I need to search for either, any idea on the best way to do this? Should I just define another condition and copy the condition but search for each item separately?

[mikeloc]

I believe any of these could work, with the first and last one having only one of the product type constraints on each of the searches, and the middle one using an advanced filter as shown.

The advanced filter would likely be the least performant, so I would go with one of the other two if they work for you. Oh, and if you haven’t enabled the experimental parentheses feature on the Settings >> Versions tab, you should enable it.

[keith]

The “OR” operator via-a-via searches is “merged with”:

How to set OR not AND in a repeating group search

As you know, multiple constraints in a Search are logically ANDed together. There are multiple ways to accomplish OR constraints: While what others say above is true – you can do a :filter operation with the Advanced condition (which is one of the few iteration techniques we have in vanilla Bubble) – note that the use of the Advanced condition results in us fetching the entire list in order to process it. (For non-advanced filters, it looks like Bubble understands that the search constraint c…

[darren.james7518]

@mikeloc

The advanced filter would likely be the least performant, so I would go with one of the other two if they work for you. Oh, and if you haven’t enabled the experimental parentheses feature on the Settings >> Versions tab, you should enable it.

Thanks so much Mike, this will solve the issue for me