Find
Introduction
The "Find" step retrieves entries from a specified table in the database based on defined conditions. This step is ideal for fetching data with precise filtering and sorting options.
Configuration
Table: Specifies the table to retrieve data from. This parameter is required.
Limit: Defines the maximum number of entries to retrieve. This parameter is required. Default: 10.
Skip: Specifies the number of entries to skip before retrieving results. This parameter is required. Default: 0.
Order: Specifies the sorting criteria for the results. Includes:
Column: The column by which to sort. Options are derived from the table's schema.
Direction: The sort direction (e.g., ascending or descending).
Subpaths
Filter: Provides access to the columns of the specified table for use in filters, order definitions, or other custom conditions.
Outputs
Values: A list of retrieved entries. Each entry is represented as a row object containing values for all columns in the table.
Last updated