Search

data": "Column5.Name" }, { "data": "Column6.Name" }], "order": [1, "desc"] });

and changed the parameter order within columnDefs It applies

stateSave: true, filter: false, "order": [[sortColumn, "asc"]], "pageLength": 25, "columnDefs": [ { "type" : "html", "targets": ['no-sort'], "orderable": false, }, ], "autoWidth": false, "tableTools":

Interesting - your load order looks okay. Are you able to e-mail me, or PM me, the URL so I can take a look and see what is going wrong? Regards, Allan

I just noticed that the second part of the problem is still there. When you click on the list of options at the bottom of the column, there is some garble and it isn't in alphabetical order.

db'))."' FROM ($baseSql) $where $order $limit" );

for them in any order. Allan

Issue was solved... caused on order of include JS files.

I'm gonna answer my own question since I finally figured it out.... When you use obj.on("click", "selector1,selector2,selector3"... you must have the selectors listed in the same order for the off() call, otherwise some of them won't get removed. Go figure.

Hi,I am still new on this datatable,do I need to use the Server-side scripts?I found it here https://datatables.net/development/server-side/php_mysql In order the search and sorting will be working?