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.
Select a data component from the popup menu:
In the Attribute Selection window:
- on the right select related streams
- on the left, select specific attributes from the stream.
Todo-Anthony - replace images
Reusing Views
Once you have created a view, you can reuse it. In the repository, you can find a view listed under it's base stream.
Form Field Names
When you drag attributes from the Attribute Selection window 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 in a related stream, this depends on the Display Name option. For example:
Primary key → Foreign key
stream.attribute → related-stream.attribute
Company.UID → Supplier.Company-Name
Where Supplier.Company-Name has Display Name:
- selected, PhixFlow uses "Company-Name" as the label.
- not selected, PhixFlow uses "UID" as the label.
For information about primary and foreign keys and the Display Name option; see Understanding ERDs and Views.