Python: Order the results

Order the query result by column.

Parameters

• column

  (Required)

  The column to order by

• desc

  (Optional)

  Whether the rows should be ordered in descending order or not.

• foreign_table

  (Optional)

  Foreign table name whose results are to be ordered.

• nullsfirst

  (Optional)

  Order by showing nulls first

Examples

With `select()`

response = (
    supabase.table("planets")
    .select("*")
    .order("name", desc=True)
    .execute()
)

On a foreign table

response = (
    supabase.table("orchestral_sections")
    .select("name, instruments(name)")
    .order("name", desc=True, foreign_table="instruments")
    .execute()
)

Order parent table by a referenced table

response = (
    supabase.table("instruments")
    .select("name, section:orchestral_sections(name)")
    .order("section(name)", desc=False)
)