Insert excerpt | ||||||||
---|---|---|---|---|---|---|---|---|
|
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 NamesField Name
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
setupSetup
TODO ANTHONY
HTML Comment | ||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Step 1 Starting PointsOption 2
Option 2
When the component has data bound to it, the
Step 2 Select a parent stream
Step 3 Select attributes
|