This page provides details of the properties for the delete node. Overview Image Removed Image Added
Use a | Insert excerpt |
|---|
| _action_deletebulkdelete |
|---|
| _action_deletebulkdelete |
|---|
| nopanel | true |
|---|
|
node to bulk delete records on from a selected table. The Bulk Delete nodes will delete records that where the Primary Key for the selected record(s) match those on the specified tablenode 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. Example Image Removed
In \the actionflow instance illustrated in the screenshot above, an application has a list of Companies in a grid. When the user clicks the delete button, the actionflow runs. The Primary Key of the selected records on the All Companies grid are mapped onto the Input Connection Point.
The Delete Node uses the mapped Primary Key to select the records from the All Companies table and delete them| Warning |
|---|
The Bulk Delete node purges records from PhixFlow including the audit history of records where Audit Manual Changes has been enabled. To delete records and persist the audit history of the record, see Delete Node. |
Setup- When creating a Bulk Delete by default Tables with Audit Manual Changes enabled will not be shown in the available list.
- Enable Allow Audit Table to display Tables with Audit Manual Changes enabled.
| Insert excerpt |
|---|
| _property_tabs |
|---|
| _property_tabs |
|---|
| name | basic-h |
|---|
| nopanel | true |
|---|
|
| Insert excerpt |
|---|
| _parent |
|---|
| _parent |
|---|
| nopanel | true |
|---|
|
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 |
updateddeleted. This table must have a Period of Transactional. |
Data Retrieval OptionAvailable 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 for deletion. See Filter → Filter Details |
Filter ParametersThe 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
 Image Added 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
 Image Added Delete.
The Filter Types are mapped to using the incoming connection.
| Insert excerpt |
|---|
| _description |
|---|
| _description |
|---|
| nopanel | true |
|---|
|
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. |
| Insert excerpt |
|---|
_access | | nopanel | true |
|---|
| Insert excerpt |
|---|
| _description | _description |
|---|
| nopanel | true |
|---|
| | Insert excerpt |
|---|
_access | |
|