Export All data of table using server side processing datatable jquery

Question

I'm trying to integrate an HTML5 export button in a datatable by using server side processing. The data is getting exported but only those which are visible in the datatable. All I want is to export all of the data. My code is below. I'm new to it could anyone please help me out with this.

jQuery("#table_data").dataTable({
    'processing': true,
    'serverSide': true,
   "scrollX":true,
    'bSearchable': true,
    lengthMenu: [[10, 25, 100, -1], [10, 25, 100, "All"]],
    "ajax": {
        'type': 'POST',
        "url": ajax_object.ajaxurl,
        "dataType": "json",
        "data": {action: 'ajax_datatable', id: form_id}
    },
   "dom": 'Bflrtip',
    buttons: [
        {
            extend: 'csvHtml5',
            exportOptions: {
                columns: ':visible',
                modifier : {
                    // DataTables core 
                    page : 'all'    
                }                                
            }

        },
        {
            extend: 'pdfHtml5',
            exportOptions: {
                columns: ':visible',
                modifier : {
                    // DataTables core 
                    page : 'all'    
                } 
            },
            orientation: 'landscape',
            PdfSize: "A3"

        }],
        "order": [[ data.dt_column_order, "desc" ]],
    "columnDefs": [{
            "targets": [parseInt(data.dt_column_target)],
            "visible": false,
            "searchable": false
        }],
    "oLanguage": {
        "sProcessing": "<div></div><div></div><div></div><div></div><div></div>"
    },
    "fnPreDrawCallback": function (oSettings) {
        jQuery('#table_data').css('opacity', '0.2');
    },
    "fnDrawCallback": function () {
        jQuery('#table_data').css('opacity', '1');
    }
});

Please help me. What is wrong and how I can solve this problem?

Answer 1

First add the follwoing code in DataTable

"dom": 'Blfrtip',
                    "buttons": [
                        {
                            "extend": 'excel',
                            "text": '<button class="btn"><i class="fa fa-file-excel-o" style="color: green;"></i>  Excel</button>',
                            "titleAttr": 'Excel',
                            "action": newexportaction
                        },
                    ],

Then add this function inside $(document).ready() function

function newexportaction(e, dt, button, config) {
         var self = this;
         var oldStart = dt.settings()[0]._iDisplayStart;
         dt.one('preXhr', function (e, s, data) {
             // Just this once, load all data from the server...
             data.start = 0;
             data.length = 2147483647;
             dt.one('preDraw', function (e, settings) {
                 // Call the original action function
                 if (button[0].className.indexOf('buttons-copy') >= 0) {
                     $.fn.dataTable.ext.buttons.copyHtml5.action.call(self, e, dt, button, config);
                 } else if (button[0].className.indexOf('buttons-excel') >= 0) {
                     $.fn.dataTable.ext.buttons.excelHtml5.available(dt, config) ?
                         $.fn.dataTable.ext.buttons.excelHtml5.action.call(self, e, dt, button, config) :
                         $.fn.dataTable.ext.buttons.excelFlash.action.call(self, e, dt, button, config);
                 } else if (button[0].className.indexOf('buttons-csv') >= 0) {
                     $.fn.dataTable.ext.buttons.csvHtml5.available(dt, config) ?
                         $.fn.dataTable.ext.buttons.csvHtml5.action.call(self, e, dt, button, config) :
                         $.fn.dataTable.ext.buttons.csvFlash.action.call(self, e, dt, button, config);
                 } else if (button[0].className.indexOf('buttons-pdf') >= 0) {
                     $.fn.dataTable.ext.buttons.pdfHtml5.available(dt, config) ?
                         $.fn.dataTable.ext.buttons.pdfHtml5.action.call(self, e, dt, button, config) :
                         $.fn.dataTable.ext.buttons.pdfFlash.action.call(self, e, dt, button, config);
                 } else if (button[0].className.indexOf('buttons-print') >= 0) {
                     $.fn.dataTable.ext.buttons.print.action(e, dt, button, config);
                 }
                 dt.one('preXhr', function (e, s, data) {
                     // DataTables thinks the first item displayed is index 0, but we're not drawing that.
                     // Set the property to what it was before exporting.
                     settings._iDisplayStart = oldStart;
                     data.start = oldStart;
                 });
                 // Reload the grid with the original page. Otherwise, API functions like table.cell(this) don't work properly.
                 setTimeout(dt.ajax.reload, 0);
                 // Prevent rendering of the full data to the DOM
                 return false;
             });
         });
         // Requery the server with the new one-time export settings
         dt.ajax.reload();
     }