Quote:
Originally Posted by kiwidude
Hi Charles - two questions: (1) what if you want to apply multiple sort columns, and (2) if I sort by one field, is it going to be on top of whatever sorting was already applied (i.e. they become a secondary sort)?
|
The sorts behave like clicking on column headings (or at least should). As such:
- to sort on multiple columns, sort on them one at a time in reverse order.
- the sort is stable, so any existing order becomes secondary.
And you didn't ask, but
- field sorts are entered into sort history. This means that sorts of non-visible columns are preserved across db cache refreshes and db searches.