3
Improve order example
Source: supabase/supabase#29938 · opened by @jonathanstanley
The javascript api allows ordering the rows on a referenced table:
however the example is a little confusing because both the selected table and referenced table have a column called name
it took me a bit to discover the note buried at the bottom:
From there, I don't think it is clear for the reader what referencedTable does.
• Is it ascending or descending (or does it have to match the main table)?
• Is there a way to sort the main table according to the row's referenced value?
• What if the referenced table has a key override: towns:cities(name)?
I think it would be very good if the cities(name) was replaced with something like cities(id) so the reader knows the order("name") is referring to
however the example is a little confusing because both the selected table and referenced table have a column called name
it took me a bit to discover the note buried at the bottom:
From there, I don't think it is clear for the reader what referencedTable does.
• Is it ascending or descending (or does it have to match the main table)?
• Is there a way to sort the main table according to the row's referenced value?
• What if the referenced table has a key override: towns:cities(name)?
I think it would be very good if the cities(name) was replaced with something like cities(id) so the reader knows the order("name") is referring to
No pledges yet. Be the first to back this.
Comments
Similar requests
Support ordering by nested columns deeper than one level in .order()
3 votes · 0 comments
Columns should have the same order in the table editor and table update menu
4 votes · 0 comments
[Supabase-js] Support ordering numeric column ascending but push zeros and/or negatives to the end
1 vote · 0 comments
Use column order in Edit Row Modal and in Schema Visualizer
2 votes · 0 comments
Add the ability to change the position of table columns
5 votes · 0 comments
No comments yet.