Default collation for jquery datatables

Question

I am trying to set the default collation to the second column in my jquery datatable. It defaults to sorting by index 0. I use the syntax "aaSorting": [[ 1, "asc" ]] , but it highlights the column that I don’t want at boot time. How can I set the default sorting for a specific column without highlighting the column as if sorting were not involved, and index column 0 was used.

Answer 1

There are several options:

• Immediately after initializing the DataTables, delete the collation classes in the TD element in TBODY.

• Disable collation classes using http://datatables.net/ref#bSortClasses . The problem is that it will disable the sort classes for user sort requests - which may or may not be what you want.

• Let your server display the table in the required sort order and not use the default sort in the table ( aaSorting:[] ).

Answer 2

Here is the real code that does this ...

 $(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 avoid highlighting the column, change the CSS like this:

 table.dataTable tr.odd td.sorting_1 { background-color: transparent; } table.dataTable tr.even td.sorting_1 { background-color: transparent; } 

Answer 3

You can use the fnSort function, see details here:

http://datatables.net/api#fnSort

Answer 4

The best option is to disable sorting and simply submit the data with the desired sort order (from a database or other source). Try adding this to your "datatable": "bSort": false

Answer 5

Datatables supports HTML5 data- * attributes for this function.

It supports multiple columns in sort order (based on 0)

 <table data-order="[[ 1, 'desc' ], [2, 'asc' ]]"> <thead> <tr> <td>First</td> <td>Another column</td> <td>A third</td> </tr> </thead> <tbody> <tr> <td>z</td> <td>1</td> <td>$%^&*</td> </tr> <tr> <td>y</td> <td>2</td> <td>*$%^&</td> </tr> </tbody> </table> 

Now my jQuery is just $('table').DataTables(); , and I get my second and third columns sorted in desc / asc order.

Here are some other nice attributes for <table> that I reuse:

data-page-length="-1" sets the page length for All (pass 25 for page length 25) ...

data-fixed-header="true" ... Make an assumption

Answer 6

I also had this problem. I used the stateSave parameter and this made this problem.
Remove this option and the problem is resolved.

Answer 7

use this, it works for me: "order": [[1, "ASC"]],

Answer 8

This worked for me:

  jQuery('#tblPaging').dataTable({ "sort": true, "pageLength": 20 }); 

Answer 9

Just include the following code:

  $(document).ready(function() { $('#tableID').DataTable( { "order": [[ 3, "desc" ]] } ); } ); 

Full reference article with an example:

https://datatables.net/examples/basic_init/table_sorting.html