Order by multiple columns in supabase

I saw a pull request on postrest-py (https://github.com/supabase/postgrest-py/pull/495) which fixes this issue. Is there a workaround for javascript?
The query below does not work:

const { data, error } = await supabase
  .from('cities')
  .select('name, country_id')
  .order('id', { ascending: false })
  .order('name', { ascending: false })

const { data, error } = await supabase
  .from('cities')
  .select('name, country_id')
  .order('id', { ascending: false })
  .order('name', { ascending: false })

const { data, error } = await supabase
  .from('cities')
  .select('name, country_id')
  .order('id', { ascending: false })
  .order('name', { ascending: false })

const { data, error } = await supabase
  .from('cities')
  .select('name, country_id')
  .order('id', { ascending: false })
  .order('name', { ascending: false })

GitHub

fix: fixed the 'order' method for 'BaseSelectRequestBuilder' by Nik...

Fixed the 'order' method for 'BaseSelectRequestBuilder' to support multiple sorting criteria and handle sorting on foreign tables.
What kind of change does this PR i...

Order by multiple columns in supabase

Similar Threads

Similar Threads

Similar Threads