Item5976: TablePlugin needs to be able to do double column sorting

Priority:	CurrentState:	AppliesTo:	Component:	WaitingFor:
Enhancement	New	Extension	TablePlugin

Table Plugin will sort on a single column. E.g. the first or the second or the third. Sometimes you want both. Like First the Second, then where the second is the same, on the first, then on the third.

-- TWiki:Main/MartinCleaver - 02 Sep 2008

IRC conversation on 09 Oct 2009:

[15:09:12] <MTempest> MS access table view and Outlook Inbox view
[15:12:42] <MTempest> I do not know what the right terms are. In my words, a plain "click" on a column
heading does a primary sort on that column.
[15:13:01] <MTempest> Shift-click on another column heading appends a secondary sort criteria
[15:13:32] <MTempest> I do not know if it is possible to differentiate between these types of clicks in a browser.
[15:16:40] <uebera||> If we introduced an additional checkbox for each header (stating 'the sorting order
of these entries is to remain unaffected from further sorts'), this would be a more general solution.
[15:17:19] <MTempest> What if hovering over the column heading brings up a small popup for setting sort criteria?
[15:17:30] <MTempest> Then  (more complex) sorting controls only appears when you want it, and so the page
is less cluttered
[15:18:17] <ArthurClemens> sounds nice
[15:20:36] • MTempest wouldn't know how to do this
[15:22:43] <MTempest> The sort popup should always have a "sort first by this column" control.
[15:23:12] <MTempest> If the table is sorted, it should have a "then sort by this column" control.
[15:24:37] <MTempest> The popup should show the current sort criteria, and include controls to remove or
reverse each of the sort criteria.
[15:26:15] <MTempest> "Reverse" could be generalised to "modify", and that could include aspects such as
date/numeric/alphanumeric sort, and case-sensitivity

-- ArthurClemens - 09 Oct 2009