jquery datatables default sort

javascript jquery sorting datatables
Mike Flynn picture Mike Flynn · Dec 26, 2011 · Viewed 113.6k times · Source

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.

Answer

Allan Jardine picture Allan Jardine · Dec 27, 2011

There are a couple of options:

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

  2. 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.

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

Related questions

Disable sorting for a particular column in jQuery DataTables

I am using the jQuery DataTables plugin to sort the table fields. My question is: how do I disable sorting for a particular column? I have tried with the following code, but it did not work: "aoColumns": [ { "bSearchable": false }, null ] …

Read More
How may I sort a list alphabetically using jQuery?

I'm a bit out of my depth here and I'm hoping this is actually possible. I'd like to be able to call a function that would sort all the items in my list alphabetically. I've been looking through the jQuery …

Read More
How to sort an array of objects with jquery or javascript

I have an array of objects: var array = [(id, name, value),(id, name, value)]; //and so on How do I get the array to be sorted in ascending order of the atribute name (array[i][1])? I've tried to do this: …

Read More