Delete Records
Overview
The Delete Records action is used to remove specific data entries from a database or repository. It is important for maintaining clean, relevant, and up-to-date datasets by eliminating redundant, outdated, or unnecessary information.
In a workflow, this action ensures that obsolete or incorrect records are properly disposed of, reducing clutter and improving data accuracy.
This action plays a key role in data management and system optimization, ensuring workflows don’t retain unnecessary or outdated information.
Let’s explore the screens that follow, after drag-n-drop of Delete Records action on workflow canvas.
Config
Config Field | Description |
---|---|
Source Type | In this dropdown, you can select a source among various sources from which you want to delete records. Note: By default, the Source Type is Object. Other options include Model and Variable. |
Note: Fields below this will be populated based on the Source Type one chooses. If Variable and Model are chosen, only two fields of choosing specific model as well as variable and Key Field will be populated. | |
Object | In this option, you can select the object from which you want to update records. The chosen object will define the source of data for deletion. Note: Label of this field is dependent on Source Type chosen earlier. If chosen variable or model, label will be the same either variable or model as per selection. |
How many records to store? | In this option, you can specify the number of records to delete from the selected object. You can choose to delete either a single record or multiple records based on your operational needs.
|
Delete Specific Records | Check if you want to delete only specific records. |
Filters | This option enables user to filter records data from the selected object using AND and OR logical operators. These operators allow the user to create complex logic for deleting records, ensuring that only the relevant data is deleted. |
Key Field | It enables to decide which will be key field to track the records. |
Filters
Custom Logic for Multiple Filters
Additionally, you can add multiple filter conditions and define custom logic for how they should be evaluated.
AND: Provide results If all provided conditions are true
OR: Provide results If one of the provided conditions are true
Value Configurations
In this section, provide a value to compare or check against the selected field. You can provide a value by clicking on the gear icon. It opens up a screen to provide value using merge text.
Add Condition & Group Condition
Condition | Description |
---|---|
Add Condition |
|
Add Group Condition |
|