---
title: "Query Rows"
url: "https://help.flows.world/en/article/query-rows"
language: "en"
last_updated: "2026-04-02T19:18:29.973Z"
---

# 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 | customers |
| filters | status=eq.active |

  
 

**Example 3: Multiple Filters (AND)**

| **Parameter** | **Value** |
| --- | --- |
| tableName | customers |
| filters | tier=eq.Top&region=eq.Fra&is\_verified=eq.true |

  
 

**Example 4: Select Specific Columns with Sorting**

| **Parameter** | **Value** |
| --- | --- |
| tableName | customers |
| 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) |

OPERATOR REFERENCE 

| Operator | Meaning | Example |
| --- | --- | --- |
| eq | equals | name=eq.John |
| neq | not equals | status=neq.inactive |
| gt | greater than | age=gt.18 |
| gte | greater than or equal | price=gte.50 |
| lt | less than | age=lt.65 |
| lte | less than or equal | price=lte.200 |
| like | pattern match (case sensitive) | name=like.Mar\* |
| ilike | pattern match (case insensitive) | email=ilike.\*@gmail.com |
| in | in a list | status=in.(active,pending) |
| is | null check | deleted\_at=is.null |