Data Sorting issue

diego30k

Hi, I got a problem with data sorting. I load my data from a database specifying a order (e.g. ORDERY BY xxxxx ASC). The problem is that Datables, by default, order my data according to the first table colum. So I need my data order by the SQL Statement (the column I use to order is NOT shown in the datatable).

Karin

Try to use "aaSorting": [] in the creation of the datatable. This should leave the data in the order it is received.

http://datatables.net/examples/basic_init/table_sorting.html
http://datatables.net/examples/basic_init/multi_col_sort.html