jquery datatables default sort not working

Question

I have a 4 column table, I want the first 3 columsn to be sortable by the user, but not the 4th, this is working fine. I also want the 3rd column to sort in ASC order by default. This part isn't working, I cant get any of the columns to sort by default and can't figure out what's wrong with my syntax:

$(document).ready(function() {
$(".table-sortable").dataTable({
    aaSorting: [],
    bPaginate: false,
    bFilter: false,
    bInfo: false,
    bSortable: true,
    bRetrieve: true,
    aoColumnDefs: [
        { "aTargets": [ 0 ], "bSortable": true },
        { "aTargets": [ 1 ], "bSortable": true },
        { "aTargets": [ 2 ], "asSorting": [ "asc" ], "bSortable": true },
        { "aTargets": [ 3 ], "bSortable": false }
    ]
}); 
});

Here's what I've been working from: http://datatables.net/usage/columns

I did figure out what IS happening, is now its not allowing that type of sort on column 3. I tried adding "desc", "asc", "asc" but no success. — turbo2oh
– turbo2oh, Commented Sep 13, 2012 at 16:16

BLSully · Accepted Answer · 2012-09-13 16:27:51Z

36

This should get you what you need

$(document).ready(function() {
    $(".table-sortable").dataTable({
        aaSorting: [[2, 'asc']],
        bPaginate: false,
        bFilter: false,
        bInfo: false,
        bSortable: true,
        bRetrieve: true,
        aoColumnDefs: [
            { "aTargets": [ 0 ], "bSortable": true },
            { "aTargets": [ 1 ], "bSortable": true },
            { "aTargets": [ 2 ], "bSortable": true },
            { "aTargets": [ 3 ], "bSortable": false }
        ]
    }); 
});

The key is the aaSorting option. For some reason it's not in his 'main' Usage pages... you can find it here though http://datatables.net/ref

answered Sep 13, 2012 at 16:27

BLSully

5,9291 gold badge29 silver badges46 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

BLSully Over a year ago

@turbo2oh: Glad you've got it working. DataTables is a great plugin

Lim Over a year ago

Hi, anyone got aaSorting with if aTargets use classnames instead of column indices?

Tom Hartman Over a year ago

The only way I've gotten it to work with class names instead of column indices if with the following: 'aaSorting': [[$('.desc').index(), 'desc']] where '.desc' of the class on the column th I'd like to sort.

Suraj Sakhare Over a year ago

not working for me, only "bSortable": true -- showing sorting icon, "bSortable": false -- not showing icon. But functionality not working.

JohnGalt Over a year ago

Thank you! I couldn't figure out why "order" wasn't working for me like it showed here: datatables.net/examples/basic_init/table_sorting.html. aaSorting worked perfectly as expected. Thanks!

coudy.one · Accepted Answer · 2018-06-05 07:48:08Z

3

It worked for me. Thanks.. Initially I was using 'order':[2,'desc'] which was not working..Correct option is aaSorting

eg;

$(document).ready(function() {
    $('#example1').DataTable({
        aaSorting: [[0, 'desc']]
    });
});

edited Jun 5, 2018 at 7:48

coudy.one

1,44013 silver badges24 bronze badges

answered Jun 5, 2018 at 7:17

Preeti

5012 gold badges9 silver badges16 bronze badges

3 Comments

Ignacio Ara Over a year ago

This is not an answer, please add this text as it should be, as a comment.

JohnGalt Over a year ago

Thanks for pointing this out. This indeed works. The documentation I could find that seemed "official" showed "order" as the proper parameter, but aaSorting worked for me. Anyone know why "order" doesn't work? Bad docs?

BLSully Over a year ago

I haven't used data tables in a while now but as I remember aaSorting was pre-1.10 and order is >=1.10

Collectives™ on Stack Overflow

jquery datatables default sort not working

2 Answers 2

5 Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

5 Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related