Search

the header cells when ordering is performed on them. We can get the current order using order(). So the

which causes DataTables to order data using localeCompare, ensuring correct ordering for accented characters. You'll

DataTable('#addresses', { columns: [ { className: 'dtr-control', orderable: false, targets: 0, defaultContent:

colours of striped rows, order highlighted rows, FixedColumns and

be arranged in any order, however there are some

but not the column order. stateRestore.toggle allows this to

function because of the order that DataTables performs it's

a WHERE statement - in order to do that you

data. var siteTable = $('#sites').DataTable( { order: [ 1, 'asc' ], ajax: '../php/sites.php', columns: [ { className: 'details-control', orderable: false, data: null, defaultContent:

of the table: $('#myTable').DataTable( { order: [[2, 'asc']], rowGroup: { startRender:

I had thought the ordering was done in SQL,

Thank you very much this solved the problem with wrong sorting. But still a question, how can i exclude empty data cells then? When i've got a lot empty cells, the DESC order shows nothing but the empty cells then.

selector modifier` effects the order that the rows are

first and only after ordering on this column, use the second column to order alphabetically.

When i tried to order columns with null value,

Unfortunately there is no option to search and order the Mjoin fields at the moment You have to use columns.searchable and columns.orderable to stop them from triggering this error. Allan

The ordering information is included in

the HTML in that order. Click the HTML tab

If you want to dynamically change the visibility or order of columns, use https://datatables.net/reference/option/columns.visible and https://datatables.net/reference/api/colReorder.order()

need an example in order to offer any help.