How to hide item from colvis collection menu?

How to hide item from colvis collection menu?

thunder8848thunder8848 Posts: 1Questions: 1Answers: 0

I have certain columns that has column title in the datatables grid which has colvis support.
But I don't wanta some of them to be shown in the colvis collection menu, such as some identification id.
For example, I made a column with width zero, and get data from server response.

《table class="table table-bordered table-hover" id="tableListProvider"》
《thead》
《tr》
《th class="text-right" style="width:10%"》serialNo《/th》
《th style="width:20%"》providerName《/th》
《th style="width:0%"》providerId《/th》
《th class="text-center" style="width:70%"》Operation《/th》
《/tr》
《/thead》
《tbody》
《/tbody》
《/table》

$('#tableListProvider').dataTable({
    dom: "l<'pull-right'B>frtip",
    autoWidth: false,
    lengthChange: true,
    searching: true,
    info: true,
    paging: true,
    buttons: [
        {
            extend: 'colvis',
            text: " Choose Columns",
            className: 'btn-sm'
        }
    ],
    columns: [
        {
            data: null,
            className: 'text-right',
            render : function(data, type, row, meta) {
                return meta.settings._iDisplayStart + meta.row + 1;
            }
        },
        { data: 'providerName' },
        { data: 'providerId' , visible: false }
    ],
    //...
});

How to I modify the button for 'colvis' to hide column 'providerId' from the colvis dropdown menu?

Thanks very much!

This discussion has been closed.