Record-Action Rule

This page is for application designers who need to configure when a specific operation will change data in the table.

Overview

Record-Action Concepts

To make changes to the data in a table use a record-action. Each record-action is a single operation that can happen to a record in the table. Record-actions can create, read, update or delete a record, so are sometimes called CRUD actions. To configure Phixflow to perform several operations to the data  record-actions directly to a table. Alternatively, to configure PhixFlow to perform several operations

  • in one table, add a list of record-actions to a table or to a table-action associated with the table.
  • in different tables, add a list of record-actions to an action that is not associated with a specific table. The record-actions affect the different tables.

An action/table-action can potentially run any of the record-actions in its list. To decide which record-action to run, create a rule associated with each record-action. When the rule evaluates to true, the record-action runs, making a change to the data in the table. See Record-Action and Record-Action Rule properties.

Creating a Record-Action Rule

To use a record-action in an action and to add a rule for it:

  1. Open the table-action properties.
  2. In the toolbar of the Record-Action Rules section:
    • either click  Create New  to create a new record-action rule. 
    • or click  Stream Item Action (SIA) to open a repository list of tables.
      Expand the branch for the table, then drag its record-action into the action properties → Record-Action Rules grid.
      Double-click on row of the grid to open the record-action rule properties. 

Record-Action Rule Properties

Use the following properties to configure the conditions or rules under which the record-action will run. 

This properties pane is not available from the repository. It only opens from the Table-Action properties.

Property Pane Toolbar

For information about the toolbar options, see the Common Properties page, Toolbars and Controls section.

 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
Record-Action

Select or add a record-action.

To add or change the selected record-action, do one of the following:

  • select a record-action name from the drop-down list of all SIAs in the repository.
  • click  Create New to create a new one; see Record-Action
  • click  Stream Item Action (SIA) to open the repository Tables branch to find a record-action and drag it in. This makes it easier to find a record-action for a specific table.
Stop if True

Enter an expression. If the expression evaluates to true, PhixFlow runs this action. However, it does not:

  • evaluate any more record-action rule expressions
  • run any more of the record-action.
Expression

Enter an expression. If the expression is empty or evaluates to true, PhixFlow runs this action. To prevent an action from running in specific conditions, enter an expression that evaluates to false.

The values that represent true are:

  • any number other than 0
  • for a list: all items in the list are true
  • the following case-insensitive strings
    • true
    • t
    • yes
    • y

The values that represent false are:

  • 0 (zero)
  • any string not listed as true above including false

Order

Specify the order in which this record-action is listed in the action properties → Record-Action Rules grid. PhixFlow evaluates the record-action in order and runs those that evaluate to true in order.

 Audit Tab

Audit Summary

See the Common Properties page, Audit Summary section.

Sections on this page

Learn More

For links to all pages in this topic, see Using Table Actions.