Kotlin: Order the results

Order the query result by column.

Parameters

• column

  (Required)

  The column to order by.

• order

  (Required)

  The order to use.

• nullsFirst

  (Optional)

  Whether to order nulls first.

• referencedTable

  (Optional)

  The foreign table to order by.

Examples

With `select()`

supabase.from("countries").select(columns = Columns.list("id", "name")) \{
   order(column = "id", order = Order.ASCENDING)
\}

On a foreign table

val columns = Columns.raw("""
    name,
    cities (
        name
    )
""".trimIndent())
supabase.from("countries").select(
    columns = columns
) \{
    order(column = "id", order = Order.ASCENDING, referencedTable = "cities")
\}