By the end of this section you will be able to:
- Set a default sort order on a view
Find the table for this exercise:
- Open the analysis model
Screens and Forms 01-08: Views, filters and screens
- Open the table configuration form for Click on the table
Overall Debt Levels
, and go to the Sort Orders section. - Add a sort order:
- Press
Insert excerpt |
---|
| _addIcon |
---|
| _addIcon |
---|
nopanel | true |
---|
|
. - Name:
PaymentMeans,DebtLevel.
- Press
Insert excerpt |
---|
| _finishsave |
---|
| _finishsave |
---|
nopanel | true |
---|
|
. - Press
Insert excerpt |
---|
| _table_attributes_show |
---|
| _table_attributes_show |
---|
nopanel | true |
---|
|
under Sort Order Attributes. - Add
PaymentMeans
to the list of Sort Order Attributes. - Leave this as ascending (up arrow).
- Add
DebtLevel
to the list of Sort Order Attributes. - Update this to descending - click on the arrow, it will reverse the direction (down arrow).
- Press
Insert excerpt |
---|
| _finish |
---|
| _finish |
---|
nopanel | true |
---|
|
to save the sort order.
- Press on the table settings.
- Open the screen
Overall Debt Levels
Open the configuration form for the view Overall Debt Levels
Insert excerpt |
---|
| _view_show |
---|
| _view_show |
---|
nopanel | true |
---|
|
configuration for the view.- Set this as the Default Sort Order.
- Press
Insert excerpt |
---|
| _finish |
---|
| _finish |
---|
nopanel | true |
---|
|
to save your changes. - Go into
Insert excerpt |
---|
| _app_mode |
---|
| _app_mode |
---|
nopanel | true |
---|
|
to see the results.
Add a further sort order to the table:
- Right-click on the view and press
Insert excerpt |
---|
| _show_table_configuration |
---|
| _show_table_configuration |
---|
nopanel | true |
---|
|
- In the Sort Orders section, press
Insert excerpt |
---|
| _addIcon |
---|
| _addIcon |
---|
nopanel | true |
---|
|
- Name:
PaymentMeans,CalculationDate
- Sort by
PaymentMeans
(ascending), CalculationDate
(ascending)
You will use this sort order in the next exercise.
In PhixFlow, any saved sort order used on a view on a table can be used on any other view defined on that table. |