💾 Filtering data
How to filters your data
Filtering 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.
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:
- Name
Filter Combination
- Type
- dropdown
- Description
Select "AND" (default) to apply all filters simultaneously, or "OR" to match any single filter.
You can then define each filter with:
- Name
Not filter?
- Type
- Dropdown
- Description
Match only rows which doesn't satisfy the filter
- Name
Filter type
- Type
- Dropdown
- Description
The filter to apply
- Name
Filter name
- Type
- string
- Description
The name of the column to filter on
- Name
Filter value
- Type
- string
- Description
The value of the filter
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:
Find book with specific title
eq("title", "Harry Potter and the Philosopher's Stone")
Find books by a specific author ID
eq("author_id", 1)
Combine search criteria for author_id and title content
eq("author_id", 2)
like("title", "%Thrones%")
Find books with "Harry Potter" in the title using case-insensitive search
ilike("title", "%Harry Potter%")
Find books either by author_id 1 or with titles containing "Kings"
or("author_id.eq.1,title.like.%Kings%")
Find books by multiple author_id values
in("author_id", [1, 2])
Find books with either "Harry Potter" or "A Game of Thrones" as title
or("title.eq.Harry Potter and the Philosopher's Stone,title.eq.A Game of Thrones")
Find books with titles containing "Chamber" or "Orient"
or("title.like.%Chamber%,title.like.%Orient%")
Do you need any help? Feel free to reach out