JavaScript: Order the results

Order the query result by column.

Parameters

• column

  (Required)

  The column to order by

• options

  (Optional)

  Named parameters

Examples

With `select()`

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

On a referenced table

  const { data, error } = await supabase
    .from('orchestral_sections')
    .select(`
      name,
      instruments (
        name
      )
    `)
    .order('name', { referencedTable: 'instruments', ascending: false })

Order parent table by a referenced table

  const { data, error } = await supabase
    .from('instruments')
    .select(`
      name,
      section:orchestral_sections (
        name
      )
    `)
    .order('section(name)', { ascending: true })