How to use OR between subqueries

[gustavocarvalheira]

Hello all. I am trying to use two subqueries in query constraints but with an OR, not the standard hidden AND.

Just like the text in yellow in the image above.

Thanks a lot.
Gustavo Carvalheira

[georgecollier]

Or constraints instead of And

Yes. Bubble literally consolidates the multiple searches into a single search fully delegated to the server? Correct, the :merged with operator (at least in this context) merges the expressions into a single DB query. Or, do you just mean that in practical terms what are literally 3 separate sequential searches yield the same result as if it were a single search? Nope, I mean only single DB query will be made. FWIW, my approach in this type of situation is typically: Role is in Arbit…

Do a search where processed = No and Asset is in Search : merged with Do a search where processed = No and Block point is in search