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.
Common Capabilities
Process Data Support
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 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.
Outputs
Affected Records Count
Returns the number of records that were successfully deleted.
This value can be used for:
- Validation
- Reporting
- Conditional workflow logic
Wait All Incoming
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
Defines how the workflow behaves if this activity encounters a runtime error.
Supported strategies include Fault, Continue, Suspend, and Retry.