Insert excerpt |
---|
| _Banners |
---|
| _Banners |
---|
name | actionflow |
---|
nopanel | true |
---|
|
OverviewView Node PropertiesImage Modified When you are designing screens, you use a view to select and filter data for display. In an |
actionflowActionflow, the originating screen or component may not include all of the data that the actionflow requires. In this case, use |
a a Insert excerpt |
---|
| _action_view |
---|
| _action_view |
---|
nopanel | true |
---|
| node to select and filter additional data to use in the actionflow. |
How the actionflow processes the view data depends on whether the view is wired via a driving or lookup connection.
- For a driving connection, records are returned individually to the view node and flow one by one through the remainder of the actionflow.
- For a lookup connection, the records are returned as an array within one recordset.
- For a worked example and video explanation, see Lookup Configuration
- Lookup views require both:
- Data Attributes: the attributes being passed into the view node.
- Request Attributes: the attributes from which you need to lookup data.
Expand |
---|
| Insert excerpt |
---|
| View Action Configuration |
---|
| View Action Configuration |
---|
name | LookupvsView |
---|
nopanel | true |
---|
|
|
|
When you create a view node, PhixFlow prompts you to select the table on which this view is based. PhixFlow opens the Attributes window and the view node properties.
Drag attributes from the Attributes window and onto the Data Attributes or Request Attributes sections. You can add attributes from the base table and from related tables.
Worked ExamplesFor full details on how to create View nodes and use them to create views or lookups, including videos and worked examples, see View Action Configuration and Lookup Configuration. Insert excerpt |
---|
| _property_tabs |
---|
| _property_tabs |
---|
name | basic-h |
---|
nopanel | true |
---|
|
Insert excerpt |
---|
| _property_toolbar |
---|
| _property_toolbar |
---|
nopanel | true |
---|
|
Insert excerpt |
---|
| _parent |
---|
| _parent |
---|
nopanel | true |
---|
|
Basic SettingsField | Description |
---|
Name | Enter the name of the action node. | Primary Table | Read-only. PhixFlow displays the table where the view attribute originates. |
Data Retrieval OptionsField | Description |
---|
Data Range | Select the data range that the view node will use: - All: use all the data
- Latest: use only the latest data.
| Include History Records | Insert excerpt |
---|
| _check_box_tick |
---|
| _check_box_tick |
---|
nopanel | true |
---|
| to include superseded records in the view data. | Default Sort Order | The sort order determines the order the data is displayed. Select a sort order, or click to create a new one; see Sort Order. | Default Filter | A filter determines what data is retrieved. Select a filter, or click to create a new one; see Filter. Insert excerpt |
---|
| Filtering and Sorting Data |
---|
| Filtering and Sorting Data |
---|
name | caseSensitive |
---|
nopanel | true |
---|
|
|
Output AttributesOutput attributes are the attributes provided by the view or returned by a lookup on the view. The grid contains a list of the attributes in the view. Click Image Modified to show the list of available attributes from the primary table. Drag the attributes you want to add to the view into this list. In the list: - To edit an attribute's properties, double-click the attribute. See View Attribute.
- To delete an attribute, select it and click
Insert excerpt |
---|
| _delete |
---|
| _delete |
---|
nopanel | true |
---|
| in the Output Attributes section header.
Field | Description |
---|
Name | Enter the name of the action node. | Type | Select the type of data this attribute contains; see Understanding Data Types. - String
- Bigstring
- Integer
- Float
- Decimal
- Date
- Datetime
- Graphic
- TrueFalse
| Aggregate Function | |
|
Aggregate FunctionsFilter ParametersThese are used to perform the lookup on a view. They are assigned a value by the mapping screen in the Incoming Mappings tab and are referenced by name no pipe prefix is required. Create a new attribute- Click
- Set the Name and Type; see Attribute.
Change the properties of an attribute- Double-click an attribute in the list; see View Attribute
Delete an attribute- Right-click and select
Insert excerpt |
---|
| _delete |
---|
| _delete |
---|
nopanel | true |
---|
| .
Map a Value to the ParameterParameters are used in the request to perform a lookup, obtaining their value from an attribute in the actionflow via the mapping screen. - Click on the connector coming into the Lookup node.
- Request (Incoming) Mappings
- Map attributes from the calling action node e.g. a calculate, to the View.
- Parameters can be dynamically created and mapped by dragging attributes from the calling action node into the drag-and-drop area on the parameters side.
- Click Next
- Return (Outgoing) Mappings
- Map attributes returned by the view (defined in the output mappings above) to the calling action node.
- Attributes can be dynamically created on the calling action node and mapped by dragging attributes from the view attributes into the drag-and-drop area of the calling action node.
See also Lookups with Dynamic Parameters. Output Connection PointsThe grid contains a list of all output connection points. - To add a new output path, in the section toolbar click to open a new output path and set the expression; see
|
Output - Connection Points.
- To edit an existing output path, double-click it in the list to open its properties.
- To remove an output path, select one and in the section toolbar click
Insert excerpt |
---|
| _delete |
---|
| _delete |
---|
nopanel | true |
---|
| .
Insert excerpt |
---|
| _description |
---|
| _description |
---|
nopanel | true |
---|
|
Insert excerpt |
---|
| _property_tabs |
---|
| _property_tabs |
---|
name | access-h |
---|
nopanel | true |
---|
|
Insert excerpt |
---|
| _access |
---|
| _access |
---|
nopanel | true |
---|
|
|
Live Search |
---|
spaceKey | @self |
---|
additional | none |
---|
placeholder | Search all help pages |
---|
type | page |
---|
|
Panel |
---|
borderColor | #00374F |
---|
titleColor | white |
---|
titleBGColor | #00374F |
---|
borderStyle | solid |
---|
title | Sections on this page |
---|
|
Table of Contents |
---|
maxLevel | 3 |
---|
indent | 12px |
---|
style | none |
---|
|
|
Learn More
Actionflows View Action ConfigurationLookup Configuration