Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 10 Next »


This page provides details of the properties for the save action. This is a node in an actionflow.

Overview

In an actionflow, use a save action node 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.

 Properties Tab

Parent Details

If this item is within or belongs to another, its parent name is shown here. See the Parent Details section on the Common Properties page for more details.

Basic Settings

FieldDescription
NameEnter the name for the action node.
Show in the Repository

An application can have many actionflows, and an individual actionflow can have many nodes. This can lead to many items being listed under Actionflow in the repository. Use this option to omit the node from the repository.

 to display this node in the repository.

 to omit this node from the repository.

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.
TableThe 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.

In the list:

Attributes not added to this list will not be changed. 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

Description

We recommend that you always enter a description to explain the purpose of this item.

 Security Tab

Access Permissions

See the Common Properties page, Access Permissions section.

 Audit Tab

Audit Summary

See the Common Properties page, Audit Summary section.

  • No labels