Update Records
Description
The Update Records activity modifies existing records in a specified database table based on defined filter criteria. It enables controlled, automated updates during workflow execution.
Design-Time Configuration
The following properties define how the activity connects to the database and updates 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 where records will be updated.
Filter
Defines the conditions that determine which records are updated. Filters are built using the Filter Expression builder.
Column Mapping
Defines how workflow values are mapped to database columns for the update operation using the Schema Mapper.
Only the mapped columns will be updated for the records that match the filter criteria.
Timeout
Specifies the maximum time (in seconds) that the activity will wait for the update operation to complete. The default value is 600 seconds.
Wait All Incoming
The Wait All Incoming property controls how the activity behaves when it has multiple incoming execution paths.
| Option | Description |
|---|---|
| False | The activity executes whenever any incoming path completes. Each incoming completion can trigger a separate execution. |
| All Configured Incoming | The activity executes only after all design-time (configured) incoming paths have completed. If a path is skipped at runtime due to conditional logic, the activity may wait indefinitely. |
| All Active Incoming | The activity executes only after all runtime-active incoming paths have completed. Incoming paths that are not taken due to conditions are ignored, ensuring predictable execution. |
Outputs
Affected Records Count
Returns the number of records successfully updated in the target table.
This value can be used for:
- Validation
- Reporting
- Conditional workflow logic
Error Handling
This activity supports the standard On Error handler, including Fault, Continue, Suspend, and Retry.
For details, see On Error Handler.