Sorting Programmatically

hoff

I have a table which only has all the data crammed into 1 column. But I want to provide the user the ability to sort it based upon multiple hidden columns/variables.

I have seen examples of using fnSort and aaSort (when declaring the table). When I try to do the following it does not work:

view.table = $('#table-simple-units').DataTable({
                    dom: App.getTableDom(),
                    .........
                    .........
});

view.table.fnSort( [ [0,'asc'], [1,'asc'] ] );

It says fnSort is not a function and it seems like it's deprecated? What is the updated equivalent function to fnSort if I want to call it on my table variable?

I tried the following as well:

  view.table.order( [ [1,'asc'] ] );

And I get no error, but it does not update the table either. What am I missing?

ThomD

Yup, that's the legacy syntax. Documentation is here for the current version.

http://datatables.net/examples/index

Some examples of sorting. If you use the search engine, search for "order", not "sort". That's the current term.

hoff

Thank you ThomD,

I figured out how to use the .order syntax and then draw the table. It works now, thank you.

However, can you also tell me how to access the current ordering of the table?
So when I do an ordering programmatically I want to read the current setting of the table.

Thanks in advance.

ThomD

Details are in the documentatoin on order().

http://datatables.net/reference/api/order()

hoff

Thanks a bunch, I was accessing the function and not the array, silly mistake. Now it works!

hoff

If i have two columns, one that declares an amount, and a second that declares the maximum. How do I order on a calculated value between those two? I.e. use those two values to calculate the percentage of stock and then order the rows based upon that?

Can I still do this using the order function?