Query relation for multiple values

General
1

Hello,
I have table with 1:N relation ‘participants’ to Users. I want to query items with ‘participants’ User1 and User2.

I suppose AND query for both values should work, but it doesn’t:

participants.objectId = 'user1Id' AND participants.objectId = 'user2Id'
2

Hi Erik,

Unfortunately, we do not support this kind of multiple selection in one-to-many relation.
This will work only if you have just one User in your where clause.