Is there a way to disable initial sorting for jquery DataTables?

Question

I'm using the jquery DataTables plugin. From their documentation:

If sorting is enabled, then DataTables will perform a first pass sort on initialisation. You can define which column(s) the sort is performed upon, and the sorting direction, with this variable. The aaSorting array should contain an array for each column to be sorted initially containing the column's index and a direction string ('asc' or 'desc').

Is it possible to have sorting enabled but disable this first pass sort on initialization? I am currently doing the initial sort server side and need sorting functionality but don't need this initial sort functionality.

score 679 · Accepted Answer · edited Aug 11 '16 at 11:31

679

Well I found the answer set "aaSorting" to an empty array:

$(document).ready( function() {
    $('#example').dataTable({
        /* Disable initial sort */
        "aaSorting": []
    });
})

For newer versions of Datatables (>= 1.10) use order option:

$(document).ready( function() {
    $('#example').dataTable({
        /* No ordering applied by DataTables during initialisation */
        "order": []
    });
})

edited Aug 11 '16 at 11:31

BitOfUniverse

5,903
1
34
38

answered Feb 11 '11 at 00:39

smoak

14,554
6
33
33

7

This answer was a great help but it's worth noting the potential confusion caused. If col 0 is pre-sorted asc and this initial sort is disabled then when a user first clicks col 0's header it will sort in asc order. To the user this looks like nothing happens as they will expect desc order. A second click will sort desc. To get around this you can set `asSorting: ['desc', 'asc']` in `aoColumnDefs` so that the first click is a desc sort. – tomfumb Nov 05 '14 at 19:37
8

For newer versions its order: [] – Darren Apr 28 '16 at 22:14
@tomfumb Actually, there is a GUI showing it is not sorted. The first click will show the Sort being activated, even though the items do not change. That's enough for me. – Nelson Apr 11 '18 at 06:05
3

You can set it on a table level too -> ``
– Howdy_McGee Jul 09 '18 at 15:36
1

This solution wont work for me but `` works for me.
– Alper Dec 25 '18 at 17:57
TIP: Use `if(aoData[0].value == 1) { console.log("first"); }` inside `"fnServerParams": function(aoData) {}` to detect if it is the datatable initialization. – Eduardo Lucio Apr 10 '19 at 17:46

score 113 · Answer 2 · answered Aug 26 '14 at 16:37

113

As per latest api docs:

$(document).ready(function() {
    $('#example').dataTable({
        "order": []
    });
});

More Info

answered Aug 26 '14 at 16:37

Ravi Kadaboina

8,494
3
30
42

luchopintado · Answer 3 · 2014-02-07T00:52:33.473

-1

In datatable options put this:

$(document).ready( function() {
  $('#example').dataTable({
    "aaSorting": [[ 2, 'asc' ]], 
    //More options ...

   });
})

Here is the solution: "aaSorting": [[ 2, 'asc' ]],

2 means table will be sorted by third column,
asc in ascending order.

edited Feb 07 '14 at 00:52

answered Nov 24 '11 at 22:57

luchopintado

899
11
15

17

The question was how to "disable initial sorting", not how to specify another sort order. This answer is better suited to a different question. – iCollect.it Ltd Mar 03 '15 at 15:33

Is there a way to disable initial sorting for jquery DataTables?

3 Answers3

Linked

Related