This page is for application designers who need to create views of data and bind them to components on screens. Todo-Anthony- check this page is correct when the GUI is finalised.
Step 1 Select a table
- Drag a table onto a screen, this can be achieved by dragging
- a table from the list in the repository.
- a table icon from a table's properties.
- PhixFlow asks you how you want the data to be displayed, select a data component:
- The view will be added to the screen.
Step 2 Select attributes
- Drag attributes from the Attribute Selection window onto the view.
- Start with attributes from the base stream.
- Optionally, click on related streams to show additional attributes that are available.
- When you have added all the attributes you require, close the window.
Step 3 Apply filtering and sorting for records
You have now created your view and added it to a screen. Optionally, specify if you want to apply any filters or sort orders to the data records:
- Select the view you have added.
- You may need to right click the view and select Show Stream View Configuration.
- The properties tab opens:
- Select an existing Default Sort Order, Default Filter or Background Filter
- Note the filter are applied when the use sees the view, however the default view can be removed by the user.
Attribute Selection
Reusing Views
Once you have created a view, you can reuse it in multiple location. In the repository navigate the the table which onws the view, the base table, and this can be dragged onto a screen. Be aware however that changes made to the view will affect all instances of that view.
Form Fields Names
When you drag attributes from the Attribute Selection window or table onto a form, PhixFlow adds a field and label for each attribute. By default, the label is the attribute's name. However, for an attribute from a related stream, the Display Name will be shown and not the foreign key value.
For example:
Example | Base Table | Related Table | Value Displayed | Form Field Label |
---|---|---|---|---|
syntax | table.UID | RelatedTable.ForeignKey | RelatedTable Attribute set to DisplayName | - |
Example Syntax | Company.UID | Supplier.RelatedCompany | Supplier attribute set to RelatedCompanyName | Related Company Name |
Example Values | 1024 | 1024 | "Cloud and Pixel Ltd" | Related Company Name |
For information about primary and foreign keys and the Display Name option; see Understanding ERDs and Views.
Alternative setup
TODO ANTHONY