how to show and hide columns of using datatable jquery

Question

I need to show and hide the columns of the datatable after doing a javascript test, but it doesn't work good.

This is my test javascript:

if ( $('#commune_to_display').val()==""){
    $('#utable td:nth-child(2)').hide();
    $('#commune_to ').hide();
}

This test works just in the first page of the datatable, after pagination the column is still visible.

How can I fix it? thanks for help

Answer 1

You can show/hide columns as shown below. Just replace 3 and 4 with your actual column indexes.

var table = $('#utable').DataTable();
table.column(3).visible(true);    // To show
table.column(4).visible(false);   // To hide