Query Rows
The Query Rows stage allows you to retrieve data from any table in your Supabase database with powerful filtering, sorting, and column selection capabilities.
Input Parameters
| Parameter | Variable | Required | Description |
| Table Name | {{tableName}} | Yes | The name of the table to query |
| Select Columns | {{selectColumns}} | No (default: *) | Columns to return, comma-separated |
| Filters | {{filters}} | No | Filter string to identify which rows to return |
| Limit | {{limit}} | No (default: 1000) | Maximum number of rows to return |
| Order By | {{orderBy}} | No | Column to sort results by |
| Order Direction | {{orderDirection}} | No (default: asc) | Sort direction: asc or desc |
Output
| Output | Variable | Description |
| Rows | {{rows}} | Array of row objects matching your query |
| Success | {{success}} | Boolean indicating if the query succeeded |
Usage Examples
Example 1: Get All Records (No Filter)
| Parameter | Value |
| tableName | customers |
Result: Returns up to 1000 rows with all columns
Example 2: Single Filter
| Parameter | Value |
| tableName | users |
| filters | status=eq.active |
Example 3: Multiple Filters (AND)
| Parameter | Value |
| tableName | customers |
| filters | tier=eq.premium®ion=eq.north&is_verified=eq.true |
Example 4: Select Specific Columns with Sorting
| Parameter | Value |
| tableName | users |
| selectColumns | id,email,name,created_at |
| filters | status=eq.active |
| orderBy | created_at |
| orderDirection | desc |
| limit | 50 |
Example 5: Numeric Range
| Parameter | Value |
| tableName | products |
| filters | price=gte.50&price=lte.200 |
| orderBy | price |
| orderDirection | asc |
Example 6: Pattern Matching
| Parameter | Value |
| tableName | customers |
| filters | email=ilike.*@gmail.com |
Example 7: Filter with IN Operator
| Parameter | Value |
| tableName | orders |
| filters | status=in.(pending,processing,shipped) |