What is a View Action?

The   View action selects and filters additional data to use in an Actionflow. This is useful where the originating screen or component does not include all of the data that the Actionflow requires. 

Creating View Actions

1. Click the   View icon in the toolbar to display existing tables in the application
   1. Existing tables can be dragged from the Repository onto the canvas - choose   View in the pop-up box to create a View action node
2. Alternatively, drag the   View icon from the toolbar onto the canvas and select a primary table to view from the drop down list

Worked Examples

Here's a worked example using the School Data (available from the Learning Centre).

We want to be able to add and edit the courses. The first step to doing this is by creating two Open Screen Actionflows. Both will open the same screen containing an input form, but when we are adding a new course, we want an empty input form, and when we are editing an existing course, we want the input form to contain course data. SCREENSHOTS?

In this example, we are using:

• a Course Management screen containing a grid of the School Courses data - the screen was created using the Tile with Buttons template
• a Course Form screen containing form fields, associated with School Courses data by a background filter - the screen was created using the Edit Form template

To save the new or edited course, the Save Action on the input form must be configured. See 1.09 Save Action Configuration.

Note: When creating a new screen in PhixFlow, a Grid Actions wizard can configure the Create, Read, Update and Delete (CRUD) actions for you. For the purposes of understanding the mechanics of Actionflows, we will create these manually.

Updating data for one table dynamically updates data in another table

Setup the View Action

1. Open the Save Actionflow for the Teachers Form
2. Click on the input connection point to open the Connector Mappings
3. Drag the TeacherStatus attribute from the left to the Drag and Drop area on the right 
   1. Click Save
4. Drag a View Action from the toolbar onto the canvas
   1. Name: Get Courses
   2. Primary Table: choose School Courses 
   3. Select Create Action
5. Drag and drop the View action you just created onto the in connector between the input node and the Save action
6. Click on the in connector between the input node and the View node to open the Mappings
7. Drag both the TeacherID and TeacherStatus attributes from the left to the Drag and Drop area on the right
   1. Select Save
8. Click on the View Action to open the properties
   1. In the Output Attributres section, select the  icon
      1. Drag the CourseID and CourseStatus attributes into the Output Attributes section in the properties
      2. Select OK
   2. In the Data Retrieval Options section, click the  next to Filter and create a filter:
      1. Name: ByTeacher
      2. Filter Details: 
      3. Select  Apply and Close
   3. Select  Apply and Close on the properties

Setup the Calculate Action

1. Drag a View Action from the toolbar onto the canvas
   1. Name: Change Course Status
   2. Select Create Action
2. Drag and drop the Calculate action you just created onto the in connector between the View action node and the Save action node
3. Click on the in connector between the View action node and the Calculate action node
4. Map across the CourseStatus, TeacherID and TeacherStatus attributes as these are needed for the Calculate action
   1. Select Save
5. Click on the Calculate action to open its properties
6. In the output attribute section, click