Search

table's settings object fnSort order(), column().order() Order the table

formatted data, apply correct ordering and also add a

use of localeCompare to order data, allowing correct ordering for accented characters. It

Using sName to order columns with server-side processing

definitions, in decreasing priority order, but an aoColumns parameter

not supported because in order for cascade to behave

ColReorder allows the end user to modify the column order of a table through drop-and-drag of column headers. CSS JS

a styling package in order for it to function

ColReorder allows the end user to modify the column order of a table through drop-and-drag of column headers. CSS JS

a styling package in order for it to function

Not what I expected. Nor I! Can you give me a link to the page so I can debug what is going wrong please? They should appear in exactly the same order that you have your editor-field elements. Allan

existing sorting conditions, the order will be the same,

I figured out above option 2 from the Hidden Columns example. The table is initialized below with the necessary columnDefs: var t = $('#example').DataTable( { "order": [[ 0, "desc" ]], "columnDefs": [ { "targets": [ 0 ], "visible": false, "searchable": false }, ] });

Disable DataTables' default sort listener for the column using columns.orderable. Then add your own events to the elements as required. order() can be used to order the table. Allan

If you use the download builder it will show you the correct order. Allan

If you use columns.orderable it will disable the end user's ability to click a column header to trigger sorting, but still allow the sorting to be defined by the API (order()) which it sounds like is what you want. Allan

1) Use order set to an empty array. 2) Use lengthMenu. 3) Use the Buttons extension. Allan

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