This page provides details of the properties for the Bulk Delete Node.
Overview
Use a Bulk Delete node to bulk delete records from a table. The Bulk Delete node can delete all records, or those records which satisfy the specified filter criteria set on the node.
A bulk delete node will only delete records from a table with a Type of Transactional.
Properties Tab
Parent Details
If this item is within or belongs to another, its parent name is shown here. See the Parent Details section on the Common Properties page for more details.
Basic Settings
Field
Description
Name
Enter the name for the action node.
Type
Delete, allows the specification of Data Retrieval Options against the selected table to identify which records will be deleted.
Delete All, will delete all data from the selected table. The Data Retrieval Options will be hidden.
Table
The table in which the records will be deleted. This table must have a Period of Transactional.
Data Retrieval Option
Available when Type is set to Delete.
Field
Description
Data Range
Latest, selects data from the latest recordsets.
All, selects data from all recordsets (default).
Filter Criteria
Specifies the criteria by which the records will be selected. See Filter → Filter Details
Filter Parameters
The grid contains a list of incoming attributes which can be referenced by the Data Retrieval Options using the notation ConnectorName.AttributeName e.g. in.MyAttribute.
To add a new Filter Parameter, in the section toolbar click Add New and set the properties.
To edit an existing Filter Parameter, double-click it in the list to open its properties.
To remove a Filter Parameter, select one and in the section toolbar click Delete.
The Filter Types are mapped to using the incoming connection.
Description
We recommend that you always enter a description to explain the purpose of this item.
Advanced Settings
Field
Description
Delete Batch Size
When deleting selected records, data will be deleted in batches. Delete Batch Size determines the size of the batches. If left blank the batch size set in System Configuration → System Tuning → Delete Batch Size, is used as the default. The System Configuration value can be overridden with this batch size.
Prioritise throughput over ordering
When this option is ticked records are processes in parallel to optimise performance. This means the order records are processed is nondeterministic.
When unticked (default), records are processed in the order they are provided.
Audit Tab
Audit Summary
See the Common Properties page, Audit Summary section.