Home

Using filters

Filters can be used on select(), update(), and delete() queries. If a Stored Procedure returns a table response, you can also apply filters. Filters must be applied to the end of queries and can also be chained together to produce advanced queries.


final res = await supabase
  .from('cities')
  .select('name, country_id')
  .eq('name', 'The Shire')    // Correct
  .execute();

final res = await supabase
  .from('cities')
  .eq('name', 'The Shire')    // Incorrect
  .select('name, country_id')
  .execute();