All topics

Join tables

Vizualinx

27 days ago
How do I join Supabase tables?
Tom Ireland

27 days ago
If using the API, you can use the select query. You would add the table name and then columns in brackets.

The PostgREST docs have some information on this where Supabase is lacking: https://docs.postgrest.org/en/v12/references/api/resource_embedding.html#foreign-key-joins
@Tom Ireland
If using the API, you can use the select query. You would add the table name and then columns in brackets.

The PostgREST docs have some information on this where Supabase is lacking: https://docs.postgrest.org/en/v12/references/api/resource_embedding.html#foreign-key-joins
Vizualinx

27 days ago
Thanks!
Would you be able to share a screenshot how it would look in toddle?
@Vizualinx
Thanks!
Would you be able to share a screenshot how it would look in toddle?
Tom Ireland

27 days ago
Sure! It's pretty much the same format as in the docs. Here's an example call to my developers table (without the Supabase base URL). This is a deeper join because tool_id in the developer_tools table is linked to records in the tools table.

/developers?profile_complete=eq.true&select=first_name,last_name,country_code,bio,developer_tools(tool_id:tools(name,tool_url))
@Tom Ireland
Sure! It's pretty much the same format as in the docs. Here's an example call to my developers table (without the Supabase base URL). This is a deeper join because tool_id in the developer_tools table is linked to records in the tools table.

/developers?profile_complete=eq.true&select=first_name,last_name,country_code,bio,developer_tools(tool_id:tools(name,tool_url))
Vizualinx

27 days ago
Got that, I just don't get how to do it in the toddle UI ..
Tom Ireland

27 days ago
Query params
profile_complete and select are query params. The rest in between is the values I'm providing, which includes columns and the joining by table name.
Tom Ireland

27 days ago
One trick I use is to pass each column as an array item in a formula and then convert to string. You get your commas for free then and it makes it easier to add/remove columns instead of typing in the field.
@Vizualinx
How do I join Supabase tables?
Lucas G

27 days ago
Same thing as what you say the other day on the video lol. It's a supabase (technically PostgREST) feature, it's the same everywhere 😂
select (*), table-two(*)
That would pull everything from first table and everything from second table
Vizualinx

27 days ago
Ohhh, got it. Just need to put it all in one line.

Thanks guys!
👍1
Tod

27 days ago
Great energy @Vizualinx! Your continuous contribution to the toddle Community just made you advance to Community Level 16!

Join tables

Vizualinx

Tom Ireland

Vizualinx

Tom Ireland

Vizualinx

Tom Ireland

Tom Ireland

Lucas G

Vizualinx

Tod

Stop scrolling. Start building.

Chat with @team-toddle

Video call our CEO

Get in touch!

Product

Company

Resources

Community