Search

select: true, stateSave: true, order: [[1, 'desc']], // Declare the

in, then parse it, order it and filter it

column_order = array(null,'att.emp_id','u.Name','date_format(att.added_date, "%d-%m-%Y")','pg.key_geographic_area','TIMESTAMPDIFF(HOUR,min(att.added_date),max(att.added_date))','min(att.added_date)','max(att.added_date)'); $this->db->_protect_identifiers=false; $order = array('date_format(att.added_date, "%Y-%m-%d %H:%i:%s")'=> 'desc');

Hi @colin I've created http://live.datatables.net/viyixepo/1/edit If you swap the order that the table search is populated and the dialog box opened, you will see the issue I get.

Unless I change the order of the statements myself,

columns: [ { data: null, defaultContent: '', orderable: false, className: 'details-control' }, { data:

20, 50, 100, -1],[10,20,50,100,"All"]], "order": [[2,'desc']], "displayLength": 25, dom:

to sort in descending order , the console shows 1

I tried to set it to "order: [4, 'desc']", but then the actives are at the bottom, they have to be on the top

JS includes (the same order you listed above) work