JavaScript: 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 array or range column to filter on

• value

  (Required)

  The array or range value to filter with

Examples

On array columns

const { data, error } = await supabase
  .from('issues')
  .select('title')
  .overlaps('tags', ['is:closed', 'severity:high'])

On range columns

const { data, error } = await supabase
  .from('reservations')
  .select()
  .overlaps('during', '[2000-01-01 12:45, 2000-01-01 13:15)')