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. All Conditions – Retrieves rows only if all specified conditions are satisfied. Any Condition – Retrieves rows if at least one of the specified conditions is satisfied.
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.

Get Row(s)

Parameters

Get Row(s)

CONTENTS