> For the complete documentation index, see [llms.txt](https://docs.flexy.bot/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.flexy.bot/modules/database/steps/find.md).

# 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.