Versions Compared

Old Version 20

changes.mady.by.user Fiona Sargeant

Saved on

compared with

New Version Current

changes.mady.by.user Zoe Baldwin

Saved on

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 save node, which is part of an actionflow.

Overview

Image Removed

Image Added

Use a

Insert excerpt
_action_save
_action_save
nopaneltrue

 action node

 node to insert

,

and update

or delete

records for a selected table.

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

Example

Image Removed

In the actionflow above a user is saving values on an edit form (Company Edit Form) to a Company table. In this workflow all changes must be approved by a second colleague. All attributes on the edit form need to be saved and a Status attribute to manually set to 'Pending Approval', StatusUpdate to the current time and StatusUpdatedBy to the users name using a calculate node.

To automatically save all the attributes on the form all the user has to do is click 'Auto Save Attributes'. This automatically saves

By default, Autosave Attributes is enabled, this saves any attributes on the driving input form

which

that link to the table on the save node.

This means if any additional fields are added to the backing table and input form they do not need to be mapped to the save node.

Create Save Stream Action pop-up Window

FieldDescriptionNameType
  • Auto InsertUpdate
  • Insert
  • Update
  • Delete
StreamClick the show list icon and Drag and drop it in from the repository

Specific attributes can be overridden manually by specifying the attributes, or if Autosave Attributes is not enabled the Save node will only save attributes which are mapped to it and ignore any that have not been included.

A Save node must be attached to a table with a Type of Transactional.

For a worked example, see Save Action Configuration.

Allocating Primary Key Values to New Records

When the save

action

node 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 Table 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 >

Show Views and Recordsets

Right-click on a

Insert excerpt
_

property

action_

tabs

save
_

property_tabsnamebasic-h

action_save
nopaneltrue
action node to display additional options.

FieldDescription
Insert excerpt
_show_views
_show_views
nopaneltrue

Show the list of views for the backing table.

Insert excerpt
_show_
parent
recordsets
_show_
parent
recordsets
nopaneltrue

Save requires a transactional table to be attached.  Dragged in when you create it - listed in the Table property

The save node will make a change to a record in the table. Depends on the selected save Type.

For Auto Insert/Update - depends on the what is passed in through the incoming connection (todo-fiona: check this is right. original phrase was "provided with"

fkldjjf

Shows the list of recordsets for the backing table. See Managing Recordsets.

Insert excerpt
_property_tabs
_property_tabs
namebasic-h
nopaneltrue

Insert excerpt
_parent
_parent
nopaneltrue

Basic Settings

FieldDescription
NameEnter the name for the action node.
Insert excerpt
_actionflow_properties
_actionflow_properties
nameshow-name
nopaneltrue

Insert excerpt
_actionflow_properties
_actionflow_properties
nameshow-text
nopaneltrue

Type
  • Auto Insert/Update

  • : Insert or update records using the following condition:
    • If the incoming connection passes in the primary key of an existing record, this save node updates the record in the attached table
    • If the incoming connection does not pass in the primary key of an existing record, this save node inserts a new record.
  • Insert

  • : 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

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

Auto Save Attributes
If selected, this action will automatically

Insert excerpt
_check_box_tick
_check_box_tick
nopaneltrue
 to save unmapped attributes from the driving input form or view, matched by

id

identifier.

  • If an attribute on the target table has not been mapped, the save
action will check
  • node checks for a value
by id (on a form the field will automatically be associated with the stream attribute if it has been added by dropping the stream attribute on the form). If there are multiple values for an attribute, the action will error. If there are no values for an attribute it will not be updated. 

Autosaving Attributes

If selected, this action will automatically save unmapped attributes from the driving input form or view, matched by id. If an attribute on the target table has not been mapped, the save action will check for a value by id (on a form the field will automatically be associated with the stream attribute if it has been added by dropping the stream attribute on the form).
  • using the identifier. This finds the attribute associated with a field that was created by dropping the attribute onto a form.
  • If there are multiple values for an attribute, the
action
  • save node will report an error.
  • If there are no values for an attribute, it will not be updated. 

Mapped Attributes

A list of attributes to be updated manually. Click 

Image Removed

Image Added to show the list of attributes for the table. Drag the attributes you want to add to the save node into this list.

In the list:

  • to edit the attribute's properties, double-click an attribute; see View Attribute
  • to delete an attribute, right-click and select 
    Insert excerpt
    _delete
    _delete
    nopaneltrue
     
Note

Attributes not added to this list will not be changed unless 'Auto Save Attributes' is ticked. If a record is being inserted and an attribute is not present in the save node, the default value for this field will be _NULL

Advanced Settings

FieldDescription
Prioritise throughput over ordering

Insert excerpt
Actionflow Properties
Actionflow Properties
namePrioritiseThroughputOverOrdering
nopaneltrue

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 .
  •  
Insert excerpt_terms_changing_terms_changingnopaneltrue