How to allow for multiple constraints in a search?

Need help Database
1

Screen Shot 2021-06-16 at 2.57.18 PM
Screen Shot 2021-06-16 at 2.57.18 PM684×1139 70.2 KB

I’m trying to have 2 possibilities when searching for something in a list. I was wondering if anyone knew how I could do this? I would like to have either of the black boxes be true for it to show up in the search. If anyone is confused on what I’m asking please let me know!

2

You will need to use :merge with and :unique item
So a first search will look for Sender = Current user and Receive = Curren’s user observings user :merge with do a search for… Sender = Current user’s observing user’s and receiver = current user : unique elements

However, you can consider to have a field that have both information (involved, list of user) and you search for the list to contain Current user AND Current user’s observing user. It will reduce the number of search

3

I used the first option and it worked great! Thank you so much!

4

Wait there’s a problem. When I merge them they don’t retain their order that they were sent in. It puts one merged list after the other. In this image, test 2 should be the second message, not at the end.

Screen Shot 2021-06-16 at 3.24.40 PM
Screen Shot 2021-06-16 at 3.24.40 PM1664×1052 41.2 KB

5

use :sorted by
And select the field you wan’t to use to sort the whole list. This need to be the last step

6

Thanks Jici
Your solution helps me as well :+1: