JQuery Datatable defered loading export data to pdf, excel etc. not showing all records

Question

I'm loading data in the datatables througn ajax using

$('#DTable').DataTable( {
    "processing": true,
    "serverSide": true,
    "ajax": {
        "url": "/api/admin/business-ad"
    },
    "dom": 'Bfrtip',
    "buttons": [
       'copy', 'csv', 'excel', 'pdf', 'print'
    ]
});

considering I have 100 records in the database, at first this loads 10 records from the database. But while exporting the data to pdf/other, only that 10 records are exported.
Is there any way to export all the records instead of getting only the displayed record.

Answer 1

Try to include this in datatable({}) function.

ordering: false,

also insert exportOptions: {rows: {order: 'current',search: 'none'},}, inside buttons:[{}]

e.g:

$('#Example').DataTable({
ordering: false,
buttons: [{
text: 'PDF', 
exportOptions: 
{rows: {order: 'current',search: 'none'},},