| Insert excerpt | ||||||||
|---|---|---|---|---|---|---|---|---|
|
This page is for data modellers and screen designers who want 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).Overview
In PhixFlow, we use
| Insert excerpt | ||||||
|---|---|---|---|---|---|---|
|
| Insert excerpt | ||||||
|---|---|---|---|---|---|---|
|
| Insert excerpt | ||||||
|---|---|---|---|---|---|---|
|
Views can include attributes from different tables, provide the tables are related;
Whenever you create or edit the attributes in a view, PhixFlow displays the Available Attributes window.
The window lists:
Current and Related Tables
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
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 of the window you can find:
- the
- attributes for the selected table
To use the window,
From the current table, select- their data type
- the special aggregate function count()
Using the Available Attributes Window
- Select the attributes you want to use in the view
To select, you can
- 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
- 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.
- Click on the name of a related table to show the available attributes for that table
- Select any related attributes and drag them to the destination
- 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
Insert excerpt _attributes_show _attributes_show nopanel true
To open the view properties:
- In an ERD,
- click on a table to open its properties.
- In the Views section, click on a view name to open its properties.
- In the repository:
- Expand Tables → base table → Views.
- Double-click the view name to open its properties.
| Live Search | ||||||||
|---|---|---|---|---|---|---|---|---|
|
| Panel | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||
|
Learn More
- button