Kotlin: Column is in an array

Finds all rows whose value on the stated column is found on the specified values.

Parameters

• column

  (Required)

  The column to filter on.

• values

  (Required)

  The values to filter with.

Examples

With `select()`

supabase.from("cities").select(columns = Columns.list("name")) \{
    filter \{
       City::name isIn listOf("Rio de Janeiro", "San Francisco")
       //or
       isIn("name", listOf("Rio de Janeiro", "San Francisco"))
    \}
\}

With `update()`

val toUpdate = City(name = "Mordor")
supabase.from("cities").update(toUpdate) \{
    filter \{
       City::name isIn listOf("Rio de Janeiro", "San Francisco")
       //or
       isIn("name", listOf("Rio de Janeiro", "San Francisco"))
    \}
\}

With `delete()`

supabase.from("cities").delete \{
    filter \{
       City::name isIn listOf("Rio de Janeiro", "San Francisco")
       //or
       isIn("name", listOf("Rio de Janeiro", "San Francisco"))
    \}
\}

With `rpc()`

supabase.postgrest.rpc("echo_all_cities") \{
    filter \{
       City::name isIn listOf("Rio de Janeiro", "San Francisco")
       //or
       isIn("name", listOf("Rio de Janeiro", "San Francisco"))
    \}
\}