This page is for data modellers and screen designers who want to display data on a simple dashboard or application screendetails on the Available Attributes window.

Overview

Tables contain data that can be displayed using a View. Views let you select attributes from the table and related tables to include:

Image Removed

To display data from a table you use a view. For example, when you drag a table onto a screen canvas, PhixFlow asks if you want display the table's data as a grid, chart, card or form; these are all types of view. You can then select the attributes you want to appear in the view, as well as apply sorting and filtering; see Displaying Data (Views). Views can include attributes from different tables, provide the tables are related; see Entity Relationship Diagrams.

Whenever you create or edit the attributes in a view, PhixFlow displays the Available Attributes window. 

Image Added

• on the left:
  • the current (base) table for the view

  • tables that have a relationship to the base table

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

    
    

• on the right: the available attributes for the selected table.

To use the window,

1. From the current table, select the attributes you want to use in the view.
   To select, you can:
   • click into the tick box
   • click 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.
   Depending on where you are working, the destination might be a view on a screen or a list of attributes in the view properties.
3. Click on the name of a related table to show the available attributes for that table.
4. Select any related attributes and drag them to the destination.
5. When you have finished, click X to close the window.

To redisplay the Available Attributes window:

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

  Insert excerpt
  _attributes_show _attributes_show nopanel true

   button.

To open the view properties:

• In an ERD,
  1. click on a table to open its properties.
  2. In the Views section, click on a view name to open its properties.
• In the repository:
  1. Expand Tables → base table → Views.
  2. Double-click the view name to open its properties.