Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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

...

field and

Note: By default, this field in invisible. It will only be populated if

Update

Delete Specific Records checkbox is checked.

Config Field

Description

Source Type

In this optiondropdown, you can select a source among various sources from which you want to delete records. It allows to choose from Object, Model and Variable.

info

Note: By default, the Source Type is Object

.info

. 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 delete 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 select amount specify the number of records to update. Either you can choose Single or Multi-recorddelete from the selected object. You can choose to delete either a single record or multiple records based on your operational needs.

  • Single Record: Deletes only one record from the object, typically the first matching record.

  • Multi-Record: Deletes multiple records.

Delete Specific Records

Check if you want to delete only specific records.

Filters

It This option enables user to filter out the data for Source Type 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.

Info
Info

Reference: Filters

Key Field

It enables to decide which will be key field to track the records.

Info

Note:

  • It is advised to assign a field which contains unique value to this field.

  • By default, Id is the key field considered here.

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.

Info

Reference: Merge Text

...

Panel
panelIconId1f5e8
panelIcon:speech_left:
panelIconText🗨️
bgColor#F4F5F7

For example, you can set the Billing State to South Central Chillie.

...

Add Condition & Group Condition

Condition

Description

Add Condition

  • The Add Condition feature allows users to define multiple criteria that must be met for a validation rule to trigger.

  • This feature is used to create complex logic by combining different conditions that Salesforce evaluates before allowing a record to be saved.

Add Group Condition

  • The Add Group Condition feature allows users to group multiple conditions together, creating complex logic that involves different sets of criteria.

  • This feature is particularly useful when combining conditions that should be evaluated as a unit (logical OR within a group) or when nesting conditions for more advanced logic.

Include Page
Merge Text Config
Merge Text Config

Action Details

...

Include Page
Action Details
Action Details

...

Include Page
Manage Input Variable
Manage Input Variable
Panel
panelIconId1f5e8
panelIcon:speech_left:
panelIconText🗨️
bgColor#F4F5F7

For example, if a company wants to close its business from Malaysia and thus wants to delete all the client records from the country, thus it can use Delete action for the specifying the Filter Criteria as Billing Country Equals Malaysia.

image-20240906-061108.pngImage Added