jquery datatable: Initial sorting by aaSorting for multiple columns not working for ajax data

Question

I have two data tables in my project. First one is taking data from an array in my hand,
data table #1:

$('#table1').dataTable({
  "sPaginationType": "full_numbers",
  "iDisplayLength": 25,
  "aaSorting": [[7,'desc'],[2,'desc']],
  "bStateSave": true
});

In above table I got the result sorted as expected. But for my second table, which uses an ajax request for data, is not sorted as expected,
data table #2

$('#table2').dataTable({
  processing: true,
  serverSide: true,
  ajax: 'a valid url',
  "aaSorting": [[3,'asc'],[0,'desc']],
  "bStateSave": false,
  "iDisplayLength": 25
});

I got the column with index 3 sorted but column with index 0 is not sorted for the same values of column 3. Do anyone is facing this kind of issue? Any help or suggestions invited.

Forum discussion: datatables.net/forums/discussion/52173/… — Sibin John Mattappallil
– Sibin John Mattappallil, Commented Sep 21, 2018 at 10:23
I think you get the right answer in the forum. Your serverside script must support sorting. — davidkonrad
– davidkonrad, Commented Sep 21, 2018 at 12:46

yash · Accepted Answer · 2018-09-21 07:32:59Z

1

If you use aDataSort instead of aaSorting , you can tell a column that it should do a multi-column sort rather than just by itself. - as said over here by datatable site admin allan.

For more detail about aDataSort, go at datatable

answered Sep 21, 2018 at 7:32

yash

2,3312 gold badges25 silver badges35 bronze badges

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

1 Comment

Sibin John Mattappallil Over a year ago

Thanks @yash. I will try it out ASAP.

Collectives™ on Stack Overflow

jquery datatable: Initial sorting by aaSorting for multiple columns not working for ajax data

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