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.
Share this Doc

Get Row(s)

Or copy link

CONTENTS