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 \})