Export all rows based on filter

jigarshah17

How i can export all of the rows. I want the export to be as per applied column &/or global filter.

allan

I just added a feature to TableTools to add this ability: https://github.com/DataTables/TableTools/commit/5ec42d01224d0ecb46836a1180f890cef2862935 . Its undocumented (other than the commit comment) and unreleased, but the comment is hopefully fairly clear and you'll be able to use the code from git to get this behaviour.

Allan

jigarshah17

Thanx Allan for quick reply. I'll try it and revert you.

jigarshah17

Thanks for your help Allan, However in our case there are around 10,000 records with each page displaying around 100 records using AJAX based pagination. By any chance can we export all the 10,000 records in one go?

arvinsim

I second jigarshah17 here. Does this include the paginated results too?

allan

If you are using server-side processing, then no. In server-side processing mode, the data is all at the server, while TableTools is client-side. There are a number of discussions on this in the forum if you use the search tool.

Allan