Kotlin: Match the filter

filter() expects you to use the raw PostgREST syntax for the filter values.

Parameters

• column

  (Required)

  The column to filter on.

• operator

  (Required)

  The operator to use for the filter.

• value

  (Required)

  The value to filter with.

Examples

With `select()`

supabase.from("countries").select \{
    filter \{
       filter(column = "name", operator = FilterOperator.IN, value = "('Algeria', 'Japan')")
    \} 
\}

On a foreign table

val columns = Columns.raw("""
    name,
    cities!inner (
        name
    )
""".trimIndent())
supabase.from("countries").select(
   columns = columns
) \{
    filter \{
        filter(column = "cities.name", operator = FilterOperator.EQ, value = "Bali")
    \}
\}