21 Setting default sort orders

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:

1. Open the model Screens and Forms 01-08: Views, filters and screens
2. Open the table configuration form for Overall Debt Levels, and go to the Sort Orders section.
3. Add a sort order:
   1. Press .
   2. Name: PaymentMeans,DebtLevel.
   3. Press  Apply and Close.
   4. Press  Show attributes for <table>
       under Sort Order Attributes.
   5. Add PaymentMeans to the list of Sort Order Attributes.
   6. Leave this as ascending (up arrow).
   7. Add DebtLevel to the list of Sort Order Attributes.
   8. Update this to descending - click on the arrow, it will reverse the direction (down arrow).
   9. Press  Apply and Close to save the sort order.
4. Open the screen Overall Debt Levels
5. Open the configuration form for the view Overall Debt Levels
6. Set this as the Default Sort Order.
7. Press  Apply and Close to save your changes.
8. Go into Application Mode to see the results.

Add a further sort order to the table:

1. Name: PaymentMeans,CalculationDate
2. Sort by PaymentMeans (ascending), CalculationDate (ascending)

You will use this sort order in the next exercise.