Delete Multiple Records step
Look up and delete multiple existing records as a single operation. This Workflow Studio step removes the need to first look up a list of records and then delete each record in the list.
Roles and availability
Available as an Workflow Studio action step. Users with the action_designer role can create a custom action with one or more action steps.
Fields
| Field | Description |
|---|---|
| Table | Select the table containing the records to delete. |
| Conditions | Define the filter condition used to look up records. |
| Order by | Select the field that you want to use to sort the records when more than one record matches the defined conditions. |
| Sort Type | Determine whether to sort the records alphabetically in ascending or descending order. |
| Run Business Rules and Workflow | Determine whether to call any business rules and workflows associated with the table. |
| Don't fail on error | Specify whether to continue running the flow when there is an error. |
Action error evaluation
If this step fails
Data type: Choice
Option to continue running the next step or go to error evaluation. To use the step status code or message for a custom action error condition, see Action error evaluation.
Example
Image omitted: delete-multiple-records-action-designer.png
Example Delete Multiple Records step.
Example Delete Multiple Records step.
Note: The example is for illustration purposes only.
Outputs
| Field | Description | Data Type |
|---|---|---|
| Count | Number of records deleted. If no records are deleted, the count is 0. | Integer |
| Error Message | Message that is displayed if the step produces an error. | String |
| Status | The completion status of the step as a numeric value.- 0 \(success\) - 1 \(error\) | Choice |
Parent Topic:Workflow Studio steps