Removing column from table after initialisation

trongart

I am looking for a way to remove a column from the table, searchFilter, searchBuilder, and colVis after initialisation as in this test case: live.datatables.net/bulutulo/1/edit

It it possible to remove the Office column or alternatively to hide it from all components?

kthorngren

Most initialization options can't be changed via the API. Using destroy() or destroy and reinitializing with the new options is the way to change them.

Kevin

trongart

@kthorngren Thank you for looking into this. Since this can't be changed via the API, I'm aiming to hide the Office column in this test case in the table, searchFilter, searchBuilder and colVis:
live.datatables.net/kedudaji/1/edit

I managed to hide the column in the table, but what would be the correct way to also hide the Office column in the searchBuilder and colVis after the initial var table = $('#example').DataTable code?

kthorngren

Search Builder uses searchBuilder.columns and colvis uses columns to define which columns are included for use with the extensions. These are Datatables initialization parameters and can only be changed, as I described above, by destroying and reinitializing with the new options. There are no API's to change these.

One option could be to apply a hidden attribute to the Search Builder and colvis columns you don't want displayed. You can inspect these elements to find a suitable selector to hide them.

Kevin