Skip to main content
Version: Current

Select Records

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 Capabilities​

Process Data Support​

info

This activity supports dynamic configuration using variables from the Process Data drawer.

You can bind values from Model Data, Form Data, System Data, Enterprise Variables, and Activity Outputs.

Learn more → Using Process Data

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.

Wait All Incoming​

Execution Control

Controls how this activity behaves when multiple incoming execution paths converge.

Determines whether the activity executes when:

  • any incoming path completes, or
  • all relevant paths have completed before execution

Learn more → Execution Control

On Error​

Error Handling Strategy

Defines how the workflow behaves if this activity encounters a runtime error.

Supported strategies include Fault, Continue, Suspend, and Retry.

Learn more → Error Handling