Search

callback: $('#tbl_instruments').DataTable( { ajax : ajax_source, order : [[0, 'desc']], searching : true,

I dont know why don't work function fetch_data(){ var dataTable = $('#user_data').DataTable({ "processing":true, "serverSide":true, "order":[], "columnDefs":[{bSortable:false,targets:[2]}], "ajax":{url:"inc/ajax.php?a=fetch",type:"POST"} }); } $('a[data-toggle="tab"]').on('shown.bs.tab',function(e){ dataTable.columns.adjust().draw(); }); fetch_data();

Hi TooManyTables, Yes, I'm trying to turn off all the columns sorting and removing the sort icon. Below code works, order: false, columnDefs: [{ targets: "_all", orderable: false }],

get the data in order to then pass it

requested in the original order - empty file... I've fixed

wow, like wow, I added searchable: false, and now it seems to work! thank you Allan, could you explain me why did it need to have searchable: false, in order to work? thank you

changed the default to order the 2nd column asc.

because of the precedence order of the CSS specifications,

manageAtmFleetTable = $("#manageAtmFleetTable").DataTable({ 'ajax' : 'php_action/fetchTerminal.php', 'order' : [], }); here is fetchTerminal.php <?php

Maybe not as I need to 'format' and 'order' the datetime (most recent first) !