Search

DataTables API methods in order to perform its data

a way that the order can be specified server-side

the dom element in order to fix the problem

{"draw":4,"columns":[{"data":"Id","name":"","searchable":true,"orderable":true,"search":{"value":"","regex":false}},{"data":"Name","name":"","searchable":true,"orderable":true,"search":{"value":"","regex":false}},{"data":"Category","name":"","searchable":true,"orderable":true,"search":{"value":"","regex":false}},{"data":"Price","name":"","searchable":true,"orderable":true,"search":{"value":"","regex":false}}],"order":[{"column":1,"dir":"asc"}],"start":5,"length":5,"search":{"value":"","regex":false}} This is the Request when I am doing the paging. The "order" is also present there. I have already sorted my list; I do not want to sort it for each paging , to save cpu cycle.

and use LIMIT and ORDER BY etc and all

db'))."` FROM $table $where $order $limit"; ); so I made

Hi, Add: searchable: false, orderable: false to the first column's definition. You will also need to use order to set a default ordering column that is not the first one. Those two changes should make it work okay. Allan

something configured properly in order to make that happen?

className":"tddiv center"} ,{ "className":"tddiv center"} ] , "order": [[2,"asc"]] , dom: 'lfrtip' }); Example

null, defaultContent: '', className: 'select-checkbox', orderable: false }, { data: null, render: