Top-Level Ordering with multiple nested tables/relationships not yet supported.
Example Query:
/rest/v1/restaurant_product?select=price,product(name,country(name, continent(name)))&order=product(country(continent(name))).asc.nullslast
Ordering by this works: product(name)
Ordering by this doesn't work: product(country(continent(name)))
Environment
Description of issue
Top-Level Ordering with multiple nested tables/relationships not yet supported.
Example Query:
/rest/v1/restaurant_product?select=price,product(name,country(name, continent(name)))&order=product(country(continent(name))).asc.nullslastOrdering by this works:
product(name)Ordering by this doesn't work:product(country(continent(name)))Top-Level Ordering Documentation
https://github.com/supabase/postgrest-js/issues/198#issuecomment-1645757355