"OR" function in Do a search

Need help Database
1

Is there a workaround to having an “or” function when doing a search? Inthis case, all these constraints have to be true to return a value, but is there a way I could search for users where “S: Instagram isn’t empty” OR “S: Facebook isn’t empty”?

image
image501×546 16.7 KB

Many thanks

2

You need to use “Filtered” to do that.

Search for users(seller status=yes) :filtered
Advanced: This users S: Instagram isn’t empty or This users S: Facebook isn’t empty

3

Hi there, @phetxdphet… as @maheshkasindi mentioned, you can use an advanced filter, although, those filters can be slow because the data is filtered on the client side. Another option is to merge two searches together with the merged with operator. So, do a search for users where S: Instagram isn't empty and merge that with a search for users where S: Facebook isn't empty.

Anyway, just food for thought… hope it helps.

Best…
Mike

4

Thanks for the alternative! Yea I’ll try to not use advanced filters if I can afford to, thanks for help!

@maheshkasindi thanks for the suggestion too! I’ll use those for scenarios where I can’t use the merged with operator!