Flutter: Order the results

Orders the result with the specified column.

Parameters

• column

  (Required)

  The column to order by.

• ascending

  (Optional)

  Whether to order in ascending order. Default is `false`.

• nullsFirst

  (Optional)

  Whether to order nulls first. Default is `false`.

• referencedTable

  (Optional)

  Specify the referenced table when ordering by a column in an embedded resource.

Examples

With `select()`

final data = await supabase
  .from('countries')
  .select('id, name')
  .order('id', ascending: false);

On a referenced table

final data = await supabase
    .from('countries')
    .select('''
      name,
      cities (
        name
      )
    ''')
    .order('name', referencedTable: 'cities', ascending: false);