Repeating Group datasource use disjunctions in search

Need help Database
1

I have a repeating group populating from a database query. The search has a constraint to see whether the user is in a list on the target object. I also want to include objects where the user is in the Owner field of the object. In this situation, they are not in the member list.

So the expression would look something like:
Search for Organizations > Members contains Current User OR Owner is Current User

It’s clear to me how to create conjunctions (just add more constraints) but I can’t figure out how to express a disjunction. Can anyone help here?

2

In case someone comes across this, I figured it out. At the top level of the ui with the field ‘datasource’, after you specify you first search, you can merge the results with a second search using the ‘merged with’ keyword.

3

Yep, just a note it will stack those two lists on top of each other so you might want a :sorted after it by alphabetical or something