How can I adjust the columns after initializing server-side processing datatable?

Question

When my server-side processing datatable is loaded the header is broken. To resolve this, I added table.columns.adjust().draw() to my initComplete function:

var table = $('.table').DataTable({
   "serverSide": true,
   /// more code...
   "initComplete": function(settings, json) {
       table.columns.adjust().draw();
   }
});

This works, but it affected the pagination. The correct page is not displayed anymore. It is set back to to first page. How can I prevent this?

What DataTables version are you using?

palaѕн
– palaѕн

2020-04-16 13:55:49 +00:00
Commented Apr 16, 2020 at 13:55 — palaѕн
– palaѕн, Commented Apr 16, 2020 at 13:55
DataTables 1.10.19

peace_love
– peace_love

2020-04-16 14:00:19 +00:00
Commented Apr 16, 2020 at 14:00 — peace_love
– peace_love, Commented Apr 16, 2020 at 14:00
and DataTables Bootstrap 3 integration

peace_love
– peace_love

2020-04-16 14:00:56 +00:00
Commented Apr 16, 2020 at 14:00 — peace_love
– peace_love, Commented Apr 16, 2020 at 14:00

palaѕн · Accepted Answer · 2020-04-16 14:04:15Z

2

For DataTables version > 1.10.x, you can simply pass false to draw() api which will redraw the table but maintaining current paging position like:

table.columns.adjust().draw( false );

As mentioned in the docs:

paging false
- the ordering and search will be recalculated and the rows redrawn in their new positions. The paging will not be reset - i.e. the current page will still be shown.

edited Apr 16, 2020 at 14:04

answered Apr 16, 2020 at 14:02

palaѕн

74.2k17 gold badges123 silver badges140 bronze badges

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

2 Comments

peace_love Over a year ago

Oh thank you so great! I was searching so mucg for a solution, how did you know that?

palaѕн Over a year ago

I have been using datatable for past few years :) I have also added docs links.

Collectives™ on Stack Overflow

How can I adjust the columns after initializing server-side processing datatable?

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related