Search

data from DB and order it like this ===> $sql->order([$colName

DataTable is to: default ordering the table from his

thanks.. it worked with below: exportOptions : { modifier : { // DataTables core order : 'index', // 'current', 'applied', //'index', 'original' page : 'all', // 'all', 'current' search : 'none' // 'none', 'applied', 'removed' }, columns: [ 1, 2, 3, 4, 5, 6, 7, 8, 9, 10 ] }

limit = self::limit( $request, $columns ); $order = self::order( $request, $columns ); $where

parameters in the same order. Normally it will - its

stateSave": true, "sAjaxSource": "/server_side/scripts/DT_ProjectMilestones.php?projectID=<?=$reqId?>", "order": [[0, 'asc']], "columns" : [ null, null, null, null, { "orderable" : true, "mRender" : function (data,

return filter def ordering(self): order = "%(table)s" %dict(table = _table) if

role IN ("Administrator", "Principal" ) ORDER BY creditor_id ASC )', 'IN',

you will probably need to use several events: check the order event (sorting) or the length event for example. Alternatively you could use a timeout like this $('#giacenze').on( 'processing.dt', function () { setTimeout(function () { ordini(); }, 500); } );

<I wish there was a way to add a explicit ORDER BY in the query through SSP implementation There are numerous posts in here concerning revised implementations of the basic ssp class.