Overview

In PhixFlow, we use   Views to display data from a table. You must select which attributes from your table you wish to display in your view and this is done via the Available Attributes window. This window pops up when creating a screen or can be accessed via the  Attributes option in the screen toolbar or in the View  Properties.

Views can include attributes from different tables, provide the tables are related; see Entity Relationship Diagrams.

On the left of the window you can find:

• the current (base) table for the view

• tables that have a relationship to the base table

  Only related tables for the current application and its packages will show, even where related tables exist in other applications/packages. 

On the right of the window you can find:

• the attributes for the selected table
• their data type
• the special aggregate function count() 

Using the Available Attributes Window

1. Select the attributes you want to use in the view by:
   
   • clicking into the tick box
   • clicking in one line then shift-click in another, to select multiple consecutive attributes
   • control-click to select multiple attributes that are not consecutive
2. Drag the selected attributes to the destination
3. Click on the name of a related table to show the available attributes for that table
   1. Select any related attributes and drag them to the destination
4. When you have finished, click X to close the window

Reopening the Available Attributes Window

• On a screen, right-click on a view component and select Show Attributes...
• In the view Properties tab, in the View Attributes section, click the Show Attributes button