Record-Action Rule
- Fiona Sargeant (Unlicensed)
- Adam Campbell
- Anthony George
- Eleanor Brodie
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:
- Open the table-action properties.
- 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
Field | Description |
---|---|
Record-Action | Select or add a record-action. To add or change the selected record-action, do one of the following:
|
Stop if True | Enter an expression. If the expression evaluates to true, PhixFlow runs this action. However, it does not:
|
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
The values that represent
|
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.