Sort programmatically

neuDev33

I've just about started using DataTables and wanted to integrate a custom menu in my table. So far, I've successfully implemented a basic DataTable and gotten my custom menu displayed(by right clicking on column headers). This menu has options for sorting, grouping, hiding columns. I wanted to know how I can sort the datatable when the user clicks on a menu item. I tried

[code]$('#myTable').dataTable({ "aaSorting": [[3, "asc"]] });[/code]

However, this gives me an error saying i cannot reinit the table. Fair enough. But how do i access it's instance and sort it based on any column i wish through code?

snarf2larf

I believe you are looking for this: http://datatables.net/api#fnSort

Assign your datatable to a variable and then you can control the sorting through fnSort.

neuDev33

Exactly what I needed! Thank-you!

neuDev33

Another doubt, how can I find out whether the current column has been sorted ascending or descending?

allan

table.fnSettings().aaSorting will tell you the current sort state, but dont write to that parameter, only read from it!

Allan

neuDev33

Thanks alot Allan!