Angular-datatables server-side processing and Buttons extension. data is empty

Question

use Angular4 and angular-datatables.

Everything looks fine (pagination, column sorting, export buttons), but when I try to print/copy/export a table, it only outputs the headers, even though the rest of the data is there.

Any ideas what's should I check?

this.dtOptions = {
  pagingType: 'full_numbers',
  pageLength: 20,
  serverSide: true,
  processing: true,
  ajax: (dataTablesParameters: any, callback) => {
   this.service.getServerSidePaganated(dataTablesParameters).subscribe(resp => {
      that.cdrs = resp.data;
      callback({
        recordsTotal: resp.recordsTotal,
        recordsFiltered: resp.recordsFiltered,
        data: []
      });
    });
  },
  columns: [
    { data: 'source' },
    { data: 'destination' },
    { data: 'dateTime'},
    { data: 'callTime'},
    { data: 'timeOnHold'},
    { data: 'disposition'},
    { data: 'recordingFileName'}
  ],
  // Declare the use of the extension in the dom parameter
  dom: 'Bfrtip',
  // Configure the buttons
  buttons: [
     'print',
     'excel'
  ]
};

}

Same issue, any solution?

Raj Kumar
– Raj Kumar

2020-10-09 20:19:44 +00:00
Commented Oct 9, 2020 at 20:19 — Raj Kumar
– Raj Kumar, Commented Oct 9, 2020 at 20:19

Sarvin Khan Tabatabaie · Accepted Answer · 2021-01-29 06:12:59Z

1

you should set the callback data

 ajax: (dataTablesParameters: any, callback) => {
   this.service.getServerSidePaganated(dataTablesParameters).subscribe(resp => {
   //   that.cdrs = resp.data;  // remove this line
      callback({
        recordsTotal: resp.recordsTotal,
        recordsFiltered: resp.recordsFiltered,
        data:  resp.data  // set data
      });
    });

answered Jan 29, 2021 at 6:12

Sarvin Khan Tabatabaie

364 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Angular-datatables server-side processing and Buttons extension. data is empty

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related