Preventing some columns from being hidden?

jstemper

I have a grid that has the first two left hand columns as fixed. I would also like to prevent Button/colVis from allowing those two columns to be hidden. Is this possible?

kthorngren

This will keep the left two from being hidden by colVis.

           {    extend: 'colvis',
                text: 'Hide Columns',
                columns: ':not(:first-child, :nth-child(2))'
           },

Kevin

jstemper

I actually had to change the columns parameters to the following. As listed above it threw a jscript error.

{    extend: 'colvis',
     text: 'Hide Columns',
     columns: ':not(:nth-child(-n+2))'
}

Thanks for the help.
John

allan

As listed above it threw a jscript error.

Are you using a version of DataTables older than 1.10.13? The above should work fine with .13, but it indeed throw and error with older versions.

Allan

jstemper

I am u using 1.10.12 so that would explain the error.
I'll have to see about upgrading.

Thanks again.