CODEWITHSUNDEEP
javascriptjquerydatatables
Haris
Haris

Reputation: 763

Hide column in jQuery dataTables?

I want to hide a column in jQuery DataTables that contains Geo Zone in its th. This is what I am doing :

$(document).ready(function(){

        if(geo_zone_on_off==0){
            var _index=$("#datatable_ajax .heading th:contains(GeoZone)").index();
            var oTable=$("#datatable_ajax").DataTable();
            if(_index != -1){
                 oTable.column(_index).visible(false);
     }
        }
    });

The dataTable is loaded but the column does not get hidden. Before doing this I tried to hide it when the table was rendered and it worked fine. What I did then was:

 "initComplete": function(settings, json) {
                       if(geo_zone_on_off==0){
                        var _index=$("th.sorting:contains(GeoZone),th.no-sort:contains(GeoZone)").index();

                           if(_index != -1){
                             grid.getDataTable().column(_index).visible(false);
                           }
                       }
                       },

But it had a problem that it displayed the hidden columns when the table was loading. In order to avoid that issue I used the solution mentioned first. But it is not working although I am getting the index right. It does not give any error.

Upvotes: 6

Views: 13304

Answers (3)

davidkonrad
davidkonrad

Reputation: 85588

It dont have to be so complicated. Simply give the column a name. And why not set the visible status upon initialization? :

columnDefs: [
  { targets: <index>, name: 'geozone', visible: geo_zone_on_off == 1 }
]

Then, later on, you can change the visibility by refer to the columns name :

table.column('geozone:name').visible(false);

or 

table.column('geozone:name').visible( geo_zone_on_off == 1 );

Look at column selectors -> https://datatables.net/reference/type/column-selector

Upvotes: 2

Aman
Aman

Reputation: 449

Get Datatable object 

var table = $('#table').DataTable();

Get column target to alter visibility

var target = //Get target of column to hide for eg for third column target = 2
var column = table.column( target );

Alter visibility 

column.visible( false );

DataTable Documentation

Upvotes: 1

Prasanna Venkatesh
Prasanna Venkatesh

Reputation: 402

You want to hide a column which contains Geo Zone in th.

Try something like this 

$('table').DataTable();
    $('button').on('click',function(){
        $('th').each(function(i,e){
        if($(this).text()=='No') {
         $(this).hide();
         $('tr').each(function(){
          $(this).find('td').each(function(index,element){
            if(index==i) {
              $(this).hide();
            }
          });
         });
        }
      });
    });

See the demo

Upvotes: 0

Related Questions