Kotlin: With a common element

Only relevant for array and range columns. Match only rows where column and value have an element in common.

Parameters

• column

  (Required)

  The column to filter on.

• values

  (Required)

  The values to filter with.

Examples

On array columns

supabase.from("issues").select(columns = Columns.list("title")) {
    filter {
       Issue::tags overlaps listOf("is:closed", "severity:high")
       //or
       overlaps("tags", listOf("is:closed", "severity:high"))
    }
}

On range columns

supabase.from("issues").select(columns = Columns.list("title")) {
    filter {
       Issue::during overlaps listOf("2000-01-01 12:45", "2000-01-01 13:15")
       //or
       overlaps("during", listOf("2000-01-01 12:45", "2000-01-01 13:15"))
    }
}