Complex Multi-thing Query

Need help Database
1

I need to fill a repeating group with the results from a query on two “things”.
(Please see image below for clarification)

  1. Find Jim in Users
  2. Get the id’s of the groups he belongs to
  3. Search “Chat Group” for those id’s
  4. Return members (User type) who are not Jim
  5. Display this User info in the repeating group

query
query844×696 72.6 KB

2

Is:
-group_tags a list of texts? It should be a list of Chat groups
-members a list of texts? it should be a list of Users

Just checking first you have it set up the “Bubble way”

3

Yes, Group tags is a list of texts :frowning:

Members is a list of Users though. ( I redid that part earlier after having a problem with texts. I apparently didn’t learn my lesson though since I didn’t do it for group_tabs)

MySQL seems easier to me but I’m sure it’s just a lack of understanding on my part…

I will read your link and try again.
Thank you Tyler

4

Yea its different than normal databases where you store the id, but worth fixing it here.

Once you get the Chat groups list field set up, and assuming Jim is the Current user:
Current user's group_tags:each item's Members:minus item Current User
Will return all Users (except for himself) in each group that Jim is in

And make sure Privacy rules doesn’t limit the results, there could be a rule put in place right now that doesn’t let Jim see other Users

5

You make it look easy.
Thanks again.

1 Like