I suspect I’m encountering a Bubble quirk here and I’m willing to accept it as such, but I can’t quite figure out a workaround.
So I have the following data structure (simplified for the example)
User (email, name etc)
Group (date created etc)
GroupMember (user[User], group[Group])
In other words, a GroupMember is a User and belongs to a Group.
Now I have a RG that should display all members of a group that a selected user (in a dropdown) belongs to. This works fine when the selected user does in fact belong to a group. The issue occurs when the selected user does not belong to any group. The RG still displays group members for the first group in the database (in my example I have just one group in the database anyway) when it should be empty.
It seems that Bubble has an issue with null search results and I suspect this is the issue I’ve hit, but I’m not sure how to get around it in my specific case. Any ideas, please?
App Editor and Screenshot below: