💾 Filtering data

How to filters your data

Filters allow you to only return rows or apply operations on rows that match certain conditions.

The actions Fetch, Update, Delete and RPC offers two ways to define filters.

❗

Note: You have the option to use either one method or both, as the filters will be combined for the final query to your Supabase instance. The choice is yours.

Method 1 - Using the filters dropdown

This is easiest and the recommanded way to define filters on your actions.

You can define up-to 5 filters to apply on your query.

You can choose the filters combination with:

Title	Description	Type
Filter Combination	Select "AND" (default) to apply all filters simultaneously, or "OR" to match any single filter.	Dropdown
Not filter?	Match only rows which doesn't satisfy the filter	Yes/No
Filter type	The filter to apply	Dropdown
Filter name	The name of the column to filter on	Text
Filter value	The value of the filter	Text

Method 2 - Using Advanced filters

Apply any Supabase filter operators directly to your query by specifying a list of filters.

You can chain filters by placing one per line.

Examples:

json
eq("title", "Harry Potter and the Philosopher's Stone")

Find book with specific title

json
eq("author_id", 1)

Find books by a specific author ID

json
eq("author_id", 2)
like("title", "%Thrones%")

Combine search criteria for author_id and title content

json
ilike("title", "%Harry Potter%")

Find books with "Harry Potter" in the title using case-insensitive search

json
or("author_id.eq.1,title.like.%Kings%")

Find books either by author_id 1 or with titles containing "Kings"

json
in("author_id", [1, 2])

Find books by multiple author_id values

json
or("title.eq.Harry Potter and the Philosopher's Stone,title.eq.A Game of Thrones")

Find books with either "Harry Potter" or "A Game of Thrones" as title

json
or("title.like.%Chamber%,title.like.%Orient%")

Find books with titles containing "Chamber" or "Orient"