| Insert excerpt |
|---|
| _Banners |
|---|
| _Banners |
|---|
| name | actionflow |
|---|
| nopanel | true |
|---|
|
This page provides details of the properties for the delete node.
Overview
Delete Node Properties Image Modified
Use a | Insert excerpt |
|---|
| _action_delete |
|---|
| _action_delete |
|---|
| nopanel | true |
|---|
|
node to delete selected records from a table. Delete nodes will delete records that where the Primary Key for the selected record(s) match those on the specified table. A delete node will only delete records from a table with a Type of Transactional. | Note |
|---|
The Delete node will persist Audit History of records when they are deleted. This is achieved by superseding the previous record and adding a new deleted record into the next recordset. This persists the history of the record. |
|
If you wish to purge records from your PhixFlow system entirely |
|
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 themWorked ExampleFor full details on creating Delete nodes, including worked examples, see Delete Action Configuration. | 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. | | Table | The table in which the records will be updated. This table must have a Period of Transactional. See Table. | | Auto Save Attributes | | Insert excerpt |
|---|
| _toggle_on |
|---|
| _toggle_on |
|---|
| nopanel | true |
|---|
|
Enable to automatically delete unmapped attributes from the input, matched by the UID. |
Mapped Attributes| Field | Description |
|---|
| Name | Enter the name for the attribute mapped to the Delete node. | | Type | The data type of the attribute mapped to the Delete node. See Understanding Data Types. |
File Tidy Up Settings| Excerpt |
|---|
| Where the selected table is a | Insert excerpt |
|---|
| _tableFile |
|---|
| _tableFile |
|---|
| nopanel | true |
|---|
|
, the delete action can handle the associated file differently to the records, if required, e.g. delete the records but not the file. Note: The deletion/moving of the file occurs before the records are deleted.| Field | Description |
|---|
| When Records are Deleted... | Choose from: - Leave the associated file in the uploaded directory: leave the file on the server
- Delete the associated file: delete the file from the server
- Archive the associated file to specified directory: archive the file to a directory - see below
| | Archive Directory | Shows when Archive the associated file to specified directory is selected. Specify the directory where the archived file should be moved to. |
|
Advanced Settings| Field | Description |
|---|
| Prioritise throughput over ordering | When this option is ticked records are |
|
processed 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 |
|---|
| _description |
|---|
| _description |
|---|
| nopanel | true |
|---|
|
| Insert excerpt |
|---|
| _access |
|---|
| _access |
|---|
| nopanel | true |
|---|
|
|
| nopanel | true |
|---|
| Live Search |
|---|
| spaceKey | @self |
|---|
| additional | none |
|---|
| placeholder | Search all help pages |
|---|
| type | page |
|---|
|
| Panel |
|---|
| borderColor | #00374F |
|---|
| titleColor | white |
|---|
| titleBGColor | #00374F |
|---|
| borderStyle | solid |
|---|
| title | Sections on this page |
|---|
|
| Table of Contents |
|---|
| maxLevel | 3 |
|---|
| indent | 12px |
|---|
| style | none |
|---|
|
|
Learn More
For links to all pages in this topic, see Understanding Actionflows.
| Insert excerpt |
|---|
_terms_changing | _terms_changing