Hide tables - preselected columns

sdj

Hi there,

I have been using datatables for a year now and love its flexibility - thank you!

I am using the dynamic show and hide columns example and would like to have certain columns preselected (for hiding). Currently all columns load up and then the user has to individually unselect them. Is there a way to have a preselected list when it loads?

Thanks for your help!

-SDJ

mstrand

I'm not sure if this answers your question, but I've got some pages where I'm using { "bVisible": false } to initially hide columns that the user can then display by unchecking a check box.

It works similar to the dynamic show/hide example: http://www.datatables.net/examples/api/show_hide.html
but uses check boxes instead of the "toggle" links. When the page initially loads, a couple of the check boxes are defaulted to checked and the corresponding columns are hid using ("bVisible": false).

Please let me know if you have any questions about this.

However, I'm now starting to use colVis for this type of functionality instead of the method I mention above.

sdj

Yes, the checkbox idea will be suitable for me but I need some more info. Not sure where you set { "bVisible": false }? It would be very helpful if you could send a code example where you use it with the checkboxes.

Thanks very much!

mstrand

Sorry - I should have included the link to the documentation for bVisible: http://www.datatables.net/usage/columns

I'm using it in the aoColumns section of the initialization which can be seen in the example on the documentation page.

To toggle the hiding/showing on the columns for which I've added check boxes, the javascript looks like this:

$("#VAR11").change( function() {fnShowHide(8); } );

where 8 corresponds to the table column, the count of which starts with 0 (the left most column is column 0). VAR11 is id of the check box.

However I would also check out the ColVis plug in: http://www.datatables.net/release-datatables/extras/ColVis/
which accomplishes the same thing a bit more easier and potentially more elegantly. It didn't exist back when I had implemented the pages with the check boxes.

Matthew