Export data in server side with searching and sorting order

Export data in server side with searching and sorting order

divyeshdivyesh Posts: 2Questions: 1Answers: 0
edited December 2015 in Free community support

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.