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 32 Next »

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

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 Stream Item Action Rule

To use a stream item action in an action and to add a rule for it:

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

Stream Item Action Rule Properties

Use the following properties to configure the conditions or rules under which the stream item action will run. 

This properties tab is not available from the repository. It only opens from the Action properties.

For information about the properties toolbar, and about the sections Parent Details, Analysis Models, Description and Audit Summary, see Common Properties.  We recommend you always add a Description that explains the purpose of the item you are creating. 

For a full list of all the PhixFlow property tabs and windows, see Properties, Windows, Menus and Toolbars.

Basic Settings

FieldDescription
Stream Item Action

The name of the stream item action.

To add or change the name, do one of the following:

  • select a stream item action name from the drop-down list of all SIAs in the repository.
  • click  Create New to create a new one; see Stream-item-actions
  • click  Stream Item Action (SIA) to open the repository Tables branch to find a stream item action and drag it in. This makes it easier to find a stream item 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 stream item action rule expressions
  • run any more of the stream item actions.
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 stream item action is listed in the action properties → Stream Item Action Rules grid. PhixFlow evaluates the stream item action in order and runs those that evaluate to true in order.

  • No labels