Select Records (Deprecated)
Use Select Records for new workflows. The current activity returns DataTable and supports explicit Read All/page settings. Rebind consumers of the old Records output.
Keep the existing node when maintaining a legacy workflow until its mappings and downstream bindings have been migrated and tested. The current activity is a replacement, not a drop-in change to the old output schema.
Description
The Select Records activity retrieves data from a specified database table. It supports filtering, sorting, and limiting results, enabling efficient and controlled data retrieval during workflow execution.
Common settings
Use Process Data to bind supported inputs to workflow values or upstream outputs. See Common Activity Features for shared execution, error-handling, and output-persistence settings. Availability depends on the activity.
Design-Time Configuration
The following properties define how the activity connects to the database and retrieves records.
Connection Type
Specifies the database engine (for example, SQL Server, Oracle, MySQL). Selecting the correct type ensures compatibility with the target database.
Connection Name
Select a preconfigured database connection that defines the server, credentials, and security settings.
Schema
Specifies the database schema that contains the target table.
Table Name
Specifies the name of the database table from which records will be retrieved.
Columns
Selects the columns to be returned by the query. Retrieving only the required columns improves performance and reduces data transfer.
Filter
Defines one or more filter conditions that control which records are returned. Filters are built using the Filter Expression builder.
Records Limit
Specifies the maximum number of records to retrieve. This helps control memory usage and performance when working with large tables.
Sort Direction
Specifies the order in which records are returned:
- Ascending
- Descending
Sorting is applied based on the selected columns.
Column Mapping
Defines how database columns are mapped to workflow variables using the Schema Mapper.
Timeout
Specifies the maximum time (in seconds) that the activity will wait for the query to complete. The default value is 600 seconds.
Outputs
Records
Returns the set of records retrieved from the database. These records can be used in subsequent workflow steps for processing, validation, or decision-making.
Execution settings
Configure Wait All Incoming when execution paths converge, and On Error for failure handling. Select Inherit where available to use the workflow-level error policy.