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  OK.
   4. Press  Show attributes for <table>
      .
   5. Add PaymentMeans to the list of sorting attributes.
   6. Leave this as ascending.
   7. Add DebtLevel to the list of sorting attributes.
   8. Update this to descending - click on the arrow, it will reverse the direction.
   9. Press  OK 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  OK 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.