turn off automatic date sorting

ningurbana

My data needs the lastest date on top instead of the oldest on top. But by initial loading of datatable, it always sort the date from oldest->latest by ignoring my own date ordering. How do I turn off this initial date sorting functionality?

--Ning

Steven

I had the same problem. This is my code:


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

allan

aaSorting is the way to go here: http://datatables.net/usage/options#aaSorting

An empty array like Steven has will disable initial sorting, or you can reverse the default and put in: [[0,'desc']].

Yet another option is to use asSorting ( http://datatables.net/usage/columns#asSorting ) to set the sorting order priority for your date columns :-)

Regards,
Allan