Delete Records
Description
The Delete Records activity removes records from a specified database table based on defined filter criteria. It enables controlled, automated data cleanup during workflow execution.
Design-Time Configuration
The following properties define how the activity connects to the database and deletes records.
Connection Type
Specifies the database engine (for example, SQL Server, Oracle, MySQL, PostgreSQL). 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 deleted.
Filter
Defines the conditions that determine which records are deleted. Filters are built using the Filter Expression builder.
Timeout
Specifies the maximum time (in seconds) that the activity will wait for the delete 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 that were successfully deleted.
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.