Can't figure out how to setup my db and query

[hisoka]

Hi guys!

I have a database with 2 tables:

PEOPLE

• name
• picture-url

MEETINGS

• title
• date
• first ponent
• second ponent

I need to reference? Multireference? I’m pretty lost with databases and querys right now.

My final goal is to show a page with all the meetings I have and in each column add all the info for that event like who is the first ponent and the second and also avatar image:

Thank you!

[Teodor]

Hello,
Can one person be in more than one meeting? If yes, then you can follow the logic here: Using Multi References in the Database Manager

[hisoka]

I followed the tutorial, however, now I face another dilema.

How needs to be the server action to retrieve all the meetings + the personal info of each person?

This retrieve that:

{"query":[{"meetingID":1,"date":"24-05-2023","title":"Super Meeting May","speakers":[{"meeting_id":1,"person_id":1},{"meeting_id":1,"person_id":2}]}]}

But I would also need to retrieve the name and picture of the speakers:

Thanks for your patience.

[Teodor]

Double click here:

and add the columns you need.

[Teodor]

and maybe check this as well:

Advanced Multi Level Nested Queries with the Database Query Builder

Intro You already know how to create nested database queries in the database query builder in order to access nested data in a single database query. In this tutorial we will show you a more advanced examples, using 3 levels of nested data and database joins. We want to display courses, the students enrolled in each course and also all the courses each of the student is enrolled in. This means the final result will be a 3 level nested query: > Course Name > Student > All the cours…

[hisoka]

Thank you!