Get Row(s)
Estimated reading: 1 minute
This component allows users to retrieve one or more rows from an existing datatable based on defined conditions. It enables filtering, sorting, and limiting of data without modifying the original datatable, making it useful for lookups, validations, and downstream processing.
Parameters
| Parameter | Description |
|---|---|
| Datatable | Specifies the source DataTable from which rows will be retrieved. |
| Must Match |
Determines how the defined conditions are evaluated when selecting rows.
|
| Number of Conditions | Specifies the number of conditions (0–50) used to evaluate and filter rows. Each condition typically compares a column value against a defined criterion. |
| Sort By | Specifies the column and sort order (ascending or descending) used to organize the retrieved rows. |
| Number of Limits | Specifies the maximum number of rows to retrieve from the DataTable after applying conditions and sorting. |