Hi all. I think about this problem for weeks, but I can’t find no one good solution. May be I can’t understand something or it’s really a bug.
We have a table, for example “SomeTable” with users one-to-many relation field, field name is “users”.
And, for example, in this table exists one object O with users “A(objectId=‘a’), B(objectId=‘b’)”
So… we want to find all objects from SomeTable which contains user B. Where clause for this query “users.objectId = ‘b’”. I think that is correct and we obtained correct result: O.
But now we want to find all objects from SomeTable which NOT contains user B. Logically where clause should be is "users.objectId != ‘b’’, but we still obtained O - this is a big question and problem for me, because for this example my expected result: no objects. Or may be I am wrong?
If it’s not a bug, please prompt me a correct solution.
I tried to get around this problem: fetch all objects and manually skip objects that not contains user with objectId = ‘b’, but it’s not work in practice, because: incorrect work of pagination, limits for objects per query, time limits, etc…