...
This page provides details of the properties for the save action node. These are part of actionflows. This is a node in an actionflow.
Overview
Use In an actionflow, use a save action node in an actionflow to insert, update or delete records for a selected table.
Allocating Primary Key Values to New Records
When the save action is inserting a new record to the table, PhixFlow allocates a unique primary key value to the record. How PhixFlow allocates a value is determined by the Stream properties → Advanced → Primary Key Generator.
- Internal: By default, PhixFlow automatically allocates a unique, numeric value to the primary key attribute.
- Sequence: Configure PhixFlow to allocate a value from your own sequence using the Primary Key Generator Sequence option. see Stream > Data Generation Options and Sequence.
| 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. |
| Insert excerpt |
|---|
| _actionflow_properties |
|---|
| _actionflow_properties |
|---|
| name | show-name |
|---|
| nopanel | true |
|---|
|
| | Insert excerpt |
|---|
| _actionflow_properties |
|---|
| _actionflow_properties |
|---|
| name | show-text |
|---|
| nopanel | true |
|---|
|
|
| Type | - Auto
Will either insert or update records using the following condition:- If the node is provided with a primary key of an existing record, the node will update that record.
- If the node is not provided with a primary key of an existing record, the node will insert a new record.
- Insert
Will always insert a new record into the attached table - Update
Will always update a record for the attached table. For a record to update successfully a primary key must be provided. - Delete
Will always delete a record on the attached table. For a record to be deleted successfully a primary key must be provided.
|
| Table | The table where the data is going to be updated. |
Attributes
A list of attributes to be updated. Click 
to show the list of attributes for the table. Drag the attributes you want to add to the save node into this list.
...