I have a User with a list of other Users who are “friends”.
When doing a search, I have a constraint that says another thing’s Created By is in this list.
But it doesn’t constrain it, the list is empty but if you put “is in” or “isn’t in” then you get the same results.
Thought it might be because it is going from location search > category, so set up a search straight on category where the Creator is in an empty list on a user.
So…I added a User to the list, then deleted it. And the search then works. So the problem is, I think, wthl a null list being searched.
This is repeatable, delete the user, set them up again and it fails again.