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("characters").select \{
    filter \{
       filter(column = "name", operator = FilterOperator.IN, value = "('Han', 'Katniss')")
    \}
\}

On a foreign table

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