Restore toggled columns except for ones initially hidden

silkspin

I'm using colvis and I've also created a button to show all the toggled off columns at once. However, a couple of columns are hidden on page load because they are in child rows and only needed for search purposes. The show all makes the originally hidden columns appear again. Is there a way to exclude these columns?

buttons: [
  'colvis',
  {
    extend: 'columnVisibility',
    text: 'Show All Columns',
    visibility: true
  }
],

If it's not possible I'll just remove the button. Thanks.

allan

Easiest way is probably to use a custom button:

buttons: [
  ‘colvis’,
  {
    text: ‘Show All Columns’,
    action: function (e, dt) {
      dt.columns(...).visible( true, false ); // show selected columns, false is to disable redraw calcs for speed
      dt.columns(...).visible( false ); // hide selected columns.
    }
  }
]

Allan

silkspin

That seems to work perfectly Allan. Thanks a lot.