Select
Retrieves data from a database table.
Inputs
Table
The table to retrieve data from.
Count
The number of records to retrieve from the table.
Select
The fields to retrieve for each record. By default, no fields are retrieved.
Filter
Conditions for filtering the retrieved data. You can create conditions against the values of the record's fields or against values from previous steps in the flow. The conditions themselves behave the same as conditions in the If component.
Sort By
Options for sorting the retrieved data. You can sort one or more columns in ascending or descending order.
Group By
Options for grouping the retrieved data.
You can group columns by applying the following mathematical functions to a column:
- Count
- Sum
- Average
- Maximum
- Minimum
Outputs
Data
An array of objects representing each database record that was retrieved.
Updated 8 months ago