DataStore Query
Query data from your built-in DataStore. Use this node to read rows from any table you have created in Database Studio.
Configuration
| Field | Description | Notes |
|---|---|---|
| Operation | Choose how many rows to return | Get Many (default) returns multiple rows. Get One returns only the first matching row. |
| Table | The DataStore table to query | Select from a list of your existing tables. |
| Columns | Which columns to include in the results | Leave empty to return all columns. Select specific columns to reduce the output size. |
| Where | Filter conditions to narrow down results | Add one or more conditions (see Where Conditions below). |
Get Many Options
These fields appear only when Operation is set to Get Many:
| Field | Description | Notes |
|---|---|---|
| Order By | Column to sort results by | Optional. Select a column from the table. |
| Direction | Sort direction | Ascending (default) or Descending. |
| Limit | Maximum number of rows to return | Optional. Must be at least 1. |
| Offset | Number of rows to skip before returning results | Optional. Useful for pagination in combination with Limit. |
Additional Options
| Field | Description | Notes |
|---|---|---|
| Output Decimals as Numbers | Convert string-encoded decimal values to numbers in the output | Disabled by default. Enable when downstream nodes need numeric values rather than strings. |
Where Conditions
The Where field lets you build filter conditions without writing SQL. Each condition has three parts:
- Column -- The column to filter on.
- Operation -- The comparison operator (equals, not equals, greater than, less than, contains, starts with, ends with, in, not in, is null, is not null, is empty, is not empty).
- Value -- The value to compare against. Supports referencing data from upstream nodes using expressions.
You can combine multiple conditions with AND or OR logic.
Output
Get Many returns a list of rows, where each row is an object with column names as keys.
Get One returns a single object with column names as keys. If no rows match the conditions, an empty object is returned.
TIP
To fetch all orders from the last 7 days, set the Where condition to the date column, use the greater than operator, and reference a date value calculated by an upstream node.