Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Insert excerpt
_Banners
_Banners
nameactionflow
nopaneltrue


Excerpt
Overview

View Node Properties

Image Modified

When you are designing screens, you use a view to select and filter data for display. In an

actionflow

Actionflow, the originating screen or component may not include all of the data that the actionflow requires. In this case, use

a

Insert excerpt
_action_view
_action_view
nopaneltrue
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
    titleViews vs Lookups

    Insert excerpt
    View Action Configuration
    View Action Configuration
    nameLookupvsView
    nopaneltrue

    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 Examples

    For 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
    namebasic-h
    nopaneltrue

    Insert excerpt
    _property_toolbar
    _property_toolbar
    nopaneltrue

    Insert excerpt
    _parent
    _parent
    nopaneltrue

    Basic Settings

    FieldDescription
    NameEnter the name of the action node.
    Primary Table

    Read-only. PhixFlow displays the table where the view attribute originates.

    Data Retrieval Options

    FieldDescription
    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
    nopaneltrue
     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

    Insert excerpt
    _add
    _add
    nopaneltrue
      to create a new one; see Sort Order

    Default Filter

    A filter determines what data is retrieved.

    Select a filter, or click

    Insert excerpt
    _add
    _add
    nopaneltrue
     to create a new one; see Filter.

    Note
    titleView returns no data
    If a 

    Insert excerpt

    _action_view_action_viewnopaneltrue action returns 0 records, any subsequent action nodes will not run. For example, if an Actionflow is run containing a  Insert excerpt_action_view_action_viewnopaneltrue action connected to an Insert excerpt_action_screen_action_screennopaneltrue action, and the view action returns 0 records, the screen will not open.

    Image Removed

    Filtering and Sorting Data
    Filtering and Sorting Data
    namecaseSensitive
    nopaneltrue

    Output Attributes

    Output 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
      nopaneltrue
       in the Output Attributes section header.
    FieldDescription
    NameEnter 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

    See 

    Aggregate Functions

    Filter Parameters

    These 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

    1. Click 
      Insert excerpt
      _add
      _add
      nopaneltrue
       
    2. Set the Name and Type; see Attribute.

    Change the properties of an attribute

    1. Double-click an attribute in the list; see View Attribute

    Delete an attribute

    1. Right-click and select 
      Insert excerpt
      _delete
      _delete
      nopaneltrue
      .

    Map a Value to the Parameter

    Parameters are used in the request to perform a lookup, obtaining their value from an attribute in the actionflow via the mapping screen.

    1. Click on the connector coming into the Lookup node.
    2. Request (Incoming) Mappings 
      1. Map attributes from the calling action node e.g. a calculate, to the View.
      2. 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.
    3. Click Next
    4. Return (Outgoing) Mappings 
      1. Map attributes returned by the view (defined in the output mappings above) to the calling action node.
      2. 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 Points

    The grid contains a list of all output connection points.

    • To add a new output path, in the section toolbar click 
      Insert excerpt
      _add
      _add
      nopaneltrue
       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
      nopaneltrue
      .

    Insert excerpt
    _description
    _description
    nopaneltrue

    Insert excerpt
    _property_tabs
    _property_tabs
    nameaccess-h
    nopaneltrue

    Insert excerpt
    _access
    _access
    nopaneltrue

    Insert excerpt
    _audit
    _audit
    nopaneltrue

    Live Search
    spaceKey@self
    additionalnone
    placeholderSearch all help pages
    typepage

    Panel
    borderColor#00374F
    titleColorwhite
    titleBGColor#00374F
    borderStylesolid
    titleSections on this page

    Table of Contents
    maxLevel3
    indent12px
    stylenone

    Learn More

  • Actionflows 
  • View Action Configuration
  • Lookup Configuration