Initialize colvis button but not including columns

Carlos83

I must initialize a datatable showing the colvis button but that does not include column 14, 15, 16 in the list,
my code is the following:

    buttons:
                [
                    {
                        extend:     'colvis',
                        collectionLayout: 'fixed two-column',
                        text:       '<span style="color:white; font-size:2.5rem;" class="fa fa-plus-square-o"></span>',
                        columns:    ':gt(0)'
                    }
                ],

I can only get it to not show the first column.

I have 11 columns hidden by css style and I don't want them to be listed by the colvis button.

"columns":
            [
                {"data":"CLAVE_MOVIMIENTO", "className":"centerColumn"},        //0
                {"data":"FECHA_VENCIMIENTO", "className":"centerColumn"},       //1
                {"data":"FECHA_DOS", "className":"centerColumn"},               //2
                {"data":"REPORTOS_BANXICO", "className":"rightColumn"},         //3
                {"data":"GARANTIAS_BANXICO", "className":"rightColumn"},        //4
                {"data":"SECTOR_BANCARIO", "className":"rightColumn"},          //5
                {"data":"VALORES_ADQUIRIDOS", "className":"rightColumn"},       //6
                {"data":"SIEFORES", "className":"rightColumn"},                 //7
                {"data":"SOCIEDADES_INVERSION", "className":"rightColumn"},     //8
                {"data":"ASEG_AFIANZA", "className":"rightColumn"},             //9
                {"data":"OTROS_RESIDENTES", "className":"rightColumn"},         //10
                {"data":"RESIDENTES_PAIS", "className":"rightColumn"},          //11
                {"data":"RESIDENTES_EXTRANJEROS", "className":"rightColumn"},   //12
                {"data":"TOTAL_CIRCULACION", "className":"rightColumn"},        //13
                {"data":"DIF_FECHAS", "className":"DisplayNone"},               //14
                {"data":"TREPORTOS_BANXICO", "className":"DisplayNone"},        //15
                {"data":"TGARANTIAS_BANXICO", "className":"DisplayNone"},       //16
                {"data":"TSECTOR_BANCARIO", "className":"DisplayNone"},         //17
                {"data":"TVALORES_ADQUIRIDOS", "className":"DisplayNone"},      //18
                {"data":"TSIEFORES", "className":"DisplayNone"},                //19
                {"data":"TSOCIEDADES_INVERSION", "className":"DisplayNone"},    //20
                {"data":"TASEG_AFIANZA", "className":"DisplayNone"},            //21
                {"data":"TOTROS_RESIDENTES", "className":"DisplayNone"},        //22
                {"data":"TRESIDENTES_PAIS", "className":"DisplayNone"},         //23
                {"data":"TRESIDENTES_EXTRANJEROS", "className":"DisplayNone"},  //24
                {"data":"TTOTAL_CIRCULACION", "className":"DisplayNone"}        //25
            ],

Thanks for the help.

rfitzwater

Take a look here for a good reference: https://datatables.net/extensions/buttons/examples/column_visibility/columns.html

Carlos83

It works wonderfully, it was as follows:

columnDefs:
            [{
                targets: [14,15,16,17,18,19,20,21,22,23,24,25],
                className: 'noVis'
            }],

Thank you