How to export selected and sorted data to pdf, csv,..

Salines

Hi people,

I spend all day looking for a solution on the net, where the need to export data after I have them sorted and selected rows.

I use:
dataTables 1.10.3
tabletools 2.2.3

In the code, I put the following:

"sExtends": "xls",
"mColumns": [ 3, 4, 5, 6, 7, 8, 9 ],
"bSelectedOnly": true,
"oSelectorOpts": { "filter": "applied", "order": "current"}

I successfully export selected rows, but they are not sorted. Also I successfully sorted data export, if they are not selected rows.

Is this ever be together? Where I'm wrong?

This is my first time to use datatable & tabletools.

Thank you.

Salines

Ok, if anyone encountered this problem?

What do you recommend, server side order, load data via ajax?

If I do that then you lose the selected rows ??

Salines

I solved this with server side ordering, and a dozen lines of js code