jquery sort multiple columns - datatable

Question

I have a datatable and have 10 columns in it. I need to sort three columns 2, 3 and 4. The 4th column has two h:outputText, one - the order no. and other being the date. I need to sort by order no. for the 4th column. How could I do this? I have added the below code but it doesn't sort properly.

$('[id$=example]').dataTable({
        "bJQueryUI" : true,
        "iDisplayLength" : 10,
        "bAutoWidth" : false,
        "bRetrieve" : true,
        "bDestroy" : true,
        "aaSorting" : [],
        "bLengthChange": false,
        "aoColumnDefs": [
      { "bSortable": false, "aTargets": [ 0,1,5,6,7,8,9 ] }
   ]
});

Thanks.

Show your HTML table with sample data. Consider creating an example on jsFiddle to demonstrate your problem. — Gyrocode.com
– Gyrocode.com, Commented Nov 27, 2015 at 16:55

Abrar Khan · Accepted Answer · 2015-11-30 12:58:14Z

1

Try this one

$('[id$=example]').dataTable({

                "order": [
                    [2, 'desc']
                ],
});

answered Nov 30, 2015 at 12:58

Abrar Khan

17510 bronze badges

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

1 Comment

Just a HK developer Over a year ago

It works. Can even order by multiple columns like order: [ [2, 'desc'], [1, 'asc'] ].

Collectives™ on Stack Overflow

jquery sort multiple columns - datatable

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related