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