How to sort secondary column descending in multi-column sort

kingregistration

I'd like to have a column which is the secondary sort for any other column in descending order. In other words, when a user clicks on a column to sort, it, of course, sorts by that column first and then by that secondary column. The secondary column should always be in descending order. The one exception is where the secondary column becomes the primary column. Then it can either descending or ascending as normal.

Let me give you an example. Given a table with 5 columns (A,B,C,D,E), column B is the "secondary" column in question. I see how to set the initial sort order, so this is about sorting from user interaction. I set the initial sort order to descending for column B.

User clicks on Column C. The sort should now be C (ascending), B (descending).
User clicks on Column D. The sort should now be D (ascending), B (descending).
User clicks again on Column D. The sort should now be D (descending), B (descending).
User clicks on Column B. The sort should now be B (descending).
User clicks again on Column B. The sort should now be B (ascending).
User Clicks on Column A. The sort should now be A (ascending), B (descending).

Hopefully that made sense.

kthorngren

I think you will want to use orderFixed with the post option for column "B". For example:
http://live.datatables.net/simijapo/1/edit

Kevin

kingregistration

That did it! Thanks.