Insert excerpt

	_Banners
	_Banners
name	actionflow
nopanel	true

_action_view

Excerpt

Overview

When you are designing screens, you use a view to select and filter data for display. In an 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
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 worked example and video explanation, see View Action Configuration
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

title	Views vs Lookups

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..

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 Settings

Field	Description
Name	Enter the name of the action node.
Primary Table	Read-only. PhixFlow displays the table where the view attribute originates.

Data Retrieval Options

If a

Insert excerpt

_action_view

Field

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

Insert excerpt

	_add
	_add
nopanel	true

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
nopanel	true

to create a new one; see Filter.

Insert excerpt

	Filtering and Sorting Data
	Filtering and Sorting Data
name	caseSensitive
nopanel	true

Note

title	View returns no data


nopanel	true

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

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

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

Click
Insert excerpt
_add
_add
nopanel true
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 Parameter

Parameters 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.
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.
Click Next
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.

Note

title	View returns no data

If a

Insert excerpt

	_action_view
	_action_view
nopanel	true

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_view
nopanel	true

action connected to an

Insert excerpt

	_action_screen
	_action_screen
nopanel	true

action, and the view action returns 0 records, the screen will not open.

Image Added

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
nopanel true
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

Insert excerpt

	_audit
	_audit
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

Version	Old Version 46	New Version 47
Changes made by	Zoe Baldwin	Zoe Baldwin
Saved on	Sept 18, 2024	Sept 18, 2024

Page Comparison

Versions Compared

Key

Overview

Insert excerpt_property_tabs_property_tabsnamebasic-hnopaneltrue

Basic Settings

Data Retrieval Options

Output Attributes

Filter Parameters

Create a new attribute

Change the properties of an attribute

Delete an attribute

Map a Value to the Parameter

Output Connection Points

Insert excerpt_property_tabs_property_tabsnameaccess-hnopaneltrue

Live SearchspaceKey@selfadditionalnoneplaceholderSearch all help pagestypepage

Insert excerpt
_property_tabs
_property_tabs
name basic-h
nopanel true

Insert excerpt
_property_tabs
_property_tabs
name access-h
nopanel true

Live Search
spaceKey @self
additional none
placeholder Search all help pages
type page