Versions Compared

Key

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

Insert excerpt
_Banners
_Banners
nameactionflow
nopaneltrue


Excerpt

This page provides details of the properties for the delete node.

Overview

Use a

Insert excerpt
_action_delete
_action_delete
nopaneltrue
 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.

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 including Audit History see Bulk Delete Node

Example

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.

  1. The Primary Key of the selected records on the All Companies grid are mapped onto the Input Connection Point.
  2. The Delete Node uses the mapped Primary Key to select the records from the All Companies table and delete them.

Insert excerpt
_property_tabs
_property_tabs
namebasic-h
nopaneltrue

Insert excerpt
_parent
_parent
nopaneltrue

Basic Settings

FieldDescription
NameEnter the name for the action node.
Table

The table in which the records will be updated. This table must have a Period of Transactional.

Advanced Settings

FieldDescription
Prioritise throughput over ordering

When this option is ticked records are processes 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
nopaneltrue

Insert excerpt
_access
_access
nopaneltrue

Insert excerpt
_audit
_audit
nopaneltrue



Live Search
spaceKey@self
additionalnone
placeholderSearch all help pages
typepage

Panel
borderColor#00374F
titleColorwhite
titleBGColor#00374F
borderStylesolid
titleSections on this page

Table of Contents
maxLevel3
indent12px
stylenone


Learn More

For links to all pages in this topic, see Understanding Actionflows

Insert excerpt
_terms_changing
_terms_changing
nopaneltrue