Issue understanding nested data calls in FF via Supabase πŸ™πŸΌ

Database & APIs

πŸ‘‹πŸ» Hi everyone,

I'm a long time Bubble user so I'm not familiar with all that SQL database stuff and how relations work. Before, I just had to create a relation between two table and i could just call the linked info right away in the UI.

Now I don't really understand how can I call the good informations in a Listview from a linked database : I got a "hunt" table that stores all the hunts created on my app, a "users" table that stores all the user's informations (username, profile pic, email...), and a "hunt_players" table that mostly does the junction between all tables.

In the page I created below, I just need to display the list of the hunters that joined already joined the hunt, with their usernames and profile pictures. That's all.

However, I can't seem to find how to do so, as I can't find how to access the data of the "users" table as the listview query data is from the "hunt_players" table.

What have you tried so far?

I tried to create a first ListView with the data set to the "hunt_players" table, filtered on the page hunt's id, and inside this ListView I have an other ListView with "users" data. Then I linked each parameters to profile pic and surname, but it doesn't show anything it bugs the app.

I've seen a lot of documentation on this topic but it all seems so complicated for something that seemed so simple to do in other platforms I've used, I don't think I am doing it the right way...

Please guys help me, I'm just a FF noob who needs a bit of help πŸ™πŸΌ !!!

Did you check FlutterFlow's Documentation for this topic?
Yes
3
6 replies