Hide column in jQuery dataTables?

Question

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.

Not working is such a general way of describing an error, can you express yourself more clearly? — Icepickle
– Icepickle, Commented Aug 17, 2017 at 11:08
@Icepickle how should I elaborate it ? The column is not getting hidden thats all, though I have datatable object, column index and I am using them all right what more should I explain? — Haris
– Haris, Commented Aug 17, 2017 at 11:10
Do you ever intend to show that column? if not why drawing it at all? — bluehipy
– bluehipy, Commented Aug 17, 2017 at 11:11
I intend to. If geo_zone_on_off is set to 1 I intend to display it. @bluehipy — Haris
– Haris, Commented Aug 17, 2017 at 11:13
I would say then it is time to produce an MVCE, as this discussion with minimalistic code will bring us nowhere. There simply isn't enough code to decide what is wrong — Icepickle
– Icepickle, Commented Aug 17, 2017 at 12:08

davidkonrad · Accepted Answer · 2017-08-17 13:55:40Z

2

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

answered Aug 17, 2017 at 13:55

davidkonrad

85.7k17 gold badges211 silver badges273 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Haris Over a year ago

the problem is that the hidden column gets displayed when the datatable is loading. @davidkonrad

davidkonrad Over a year ago

@Anonymous, not if you set visible: false in columnDefs or columns.

Aman · Accepted Answer · 2017-08-17 13:29:52Z

1

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

answered Aug 17, 2017 at 13:29

Aman

4495 silver badges16 bronze badges

Comments

Prasanna Venkatesh · Accepted Answer · 2017-08-17 12:38:49Z

0

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

answered Aug 17, 2017 at 12:38

Prasanna Venkatesh

4164 silver badges16 bronze badges

Collectives™ on Stack Overflow

Hide column in jQuery dataTables?

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related