jquery datatables default sort

Question

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

User · 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

User · Answer

Datatables supports HTML5 data-  attributes for this functionality   It supports multiple columns in the sort order  it s 0-based    lt table data-order     1   desc      2   asc      gt       lt thead gt           lt tr gt               lt td gt First lt  td gt               lt td gt Another column lt  td gt               lt td gt A third lt  td gt           lt  tr gt       lt  thead gt       lt tbody gt           lt tr gt               lt td gt z lt  td gt               lt td gt 1 lt  td gt               lt td gt     amp   lt  td gt           lt  tr gt           lt tr gt               lt td gt y lt  td gt               lt td gt 2 lt  td gt               lt td gt      amp  lt  td gt           lt  tr gt       lt  tbody gt   lt  table gt    Now my jQuery is simply    table   DataTables    and I get my second and third columns sorted in desc   asc order   Here s some other nice attributes for the  lt table gt  that I find myself reusing   data-page-length  -1  will set the page length to All  pass 25 for page length 25      data-fixed-header  true      Make a guess

User · Answer

Here is the actual code that does it       document  ready function       var oTable       myTable   dataTable          Sort immediately with column 2  at position 1 in the array  base 0   More could be sorted with additional array elements   oTable fnSort     1  asc              And to sort another column descending  at position 2 in the array  base 0     oTable fnSort     2  desc               To not have the column highlighted  modify the CSS like so   table dataTable tr odd td sorting 1   background-color  transparent    table dataTable tr even td sorting 1   background-color  transparent

User · Answer

use this it works for me   order      1   ASC

User · Answer

Best option is to disable sorting and just feed data with desired sort order  from database or other source   Try to add this to your  datatable        bSort   false

User · Answer

You can use the fnSort function  see the details here   http   datatables net api fnSort

User · Answer

I had this problem too  I had used stateSave option and that made this problem  Remove this option and problem is solved

User · Answer

This worked for me          jQuery   tblPaging   dataTable                sort   true               pageLength   20

User · Answer

Just Include the following code         document  ready function                 tableID   DataTable                 order      3   desc                              Full reference article with the example    https   datatables net examples basic init table sorting html

[javascript] jquery datatables default sort

Examples related to javascript

Examples related to jquery

Examples related to sorting

Examples related to datatables