Get table data when filter and column visibility are applied by user

cdonate

Hello guys.

I have a table that is very similar to this one: http://www.datatables.net/release-datatables/extras/ColReorder/col_filter.html

I use fnSetColumnVis for the column visibility.

The user can show and hide columns and filter each column individually.

I have to send to the server a JSON message of the visible columns and filtered items.

The filtered data is ok, I can get it, but I get everything, even the hidden columns. I can't seem to combine the two, filtering and column visibility.

I tried going through the DOM, but if I have more than 10 results and pagination is happening I can only get the first page (10 lines) since they are the only ones on the DOM.

Is there a way to solve this? Any help is appreciated.

Thanks!

allan

Try using the $ and _ API methods (nodes and data respectively):

http://datatables.net/docs/DataTables/1.9.4/#$
http://datatables.net/docs/DataTables/1.9.4/#_

Allan

cdonate

Thanks Allan, using $ worked very well.