Export data in server side with searching and sorting order
Export data in server side with searching and sorting order
divyesh
Posts: 2Questions: 1Answers: 0
Hi All,
I have use this code in my client web side,
$('#example').dataTable({
"dom": 'lBfrtip',
"serverSide": true,
"ajax": "scripts/server_processing.php",
buttons: [
{
extend: 'excel',
text: 'Save all page',
exportOptions: {
modifier: {
page: 'all'
}
}
}
]
});
but, my client database is very large near about 100,000 record's in table, so i have used in server side process and all's are working fine (list,search,sort). But when i click on excel button and generate excel file at time only current page record's render in excel file,but we need all record's rendering excel file.
please help me how's it possible.
This discussion has been closed.