This page is for data modellers and screen designers who want to display data on a simple dashboard or application screen

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

details on the Available Attributes window.

Overview

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

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

The window lists:

• on the left:
  • the current (base) table for the view
  • tables that have a relationship to the base table
• 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.