Question

23

jquery datatables default sort

rated 0 times [ 26] [ 3] / answers: 1 / hits: 117322 / 13 Years ago, mon, december 26, 2011, 12:00:00

I am trying to set the default sort to the second column in my jquery datatable. It by default sorts by index 0. I am using the aaSorting: [[ 1, asc ]] syntax but it highlights the column which I don't want on initial load. How can I set the default sort of a specific column without it highlighting the column as if no sorting was involved and the 0 index column was being used.

Answers

Only authorized users can answer the question. Please sign in first, or register a free account.

gageherberth

Add To Favorites

Follow

Total Points: 249

Total Questions: 115

Total Answers: 119

Location: Liechtenstein

Member since Sun, Sep 12, 2021

3 Years ago

answered 13 Years ago emileef · Accepted Answer

There are a couple of options:

Just after initialising DataTables, remove the sorting classes on the TD element in the TBODY.

Disable the sorting classes using http://datatables.net/ref#bSortClasses . Problem with this is that it will disable the sort classes for user sort requests - which might or might not be what you want.

Have your server output the table in your required sort order, and don't apply a default sort on the table (aaSorting:[]).