How to use Export buttons with serverSide and scroller
How to use Export buttons with serverSide and scroller
Wernfried
Posts: 27Questions: 6Answers: 0
I use a table with
columnControl: [...]
ajax:'/api/data',
responsive: { orthogonal: 'responsive' },
serverSide: true,
scrollY: 300,
scrollCollapse: true,
scroller: true,
Is there a build-in method to control behavior of export buttons (e.g. csvHtml5, copyHtml5 or excelHtml5)
Problem is, it exports the currently loaded rows but with Scroller Extension you don't know which and how many rows are loaded exactly at the moment when you click the export button.
Of course, I could create a custom button which reads all search/order parameters from DataTable API, runs a AJAX request manually to get desired data and the export the data to desired format. Is there an easier way to control which rows get exported?
Kind Regards
Wernfried
Answers
See this FAQ about using the export buttons with server side processing.
Kevin