How to hide or show column of table created using datatables in javascript?

Question

Do you know how to hide or show column when datatable's source is javascript?

Methods for showing or hiding columns

 table = $('#example').DataTable();
var col = table.column("0").visible(false);

work when data source is directly into html

<table id="example" class="row-border hover">
        <thead>
            <tr>
                <th>Name</th>
                <th>Position</th>
                <th>Office</th>
                <th>Age</th>
                <th>Start date</th>
                <th>Salary</th>
            </tr>
        </thead>
        <tbody>
            <tr>
                <td>Tiger Nixon</td>
                <td>System Architect</td>
                <td>Edinburgh</td>
...

But it does not work and launch an error when DataTable has a javascript source

 var table = $('#example').dataTable({
                   "data": source,
                    "columns": columns,
                    "columnDefs": defs
    });


 var col = table.column("0").visible(false);//ERROR!

Do you know how to hide a column of Datatables with a javascript source please?

Lumi Lu · Accepted Answer · 2015-02-09 00:37:32Z

1

Try something like this,

var table = $('#example').dataTable({
  "data": source,
  "columns": columns,
  "columnDefs": [
  {
    "targets": [ 0 ],
    "visible": false,
  },
  "fnRowCallback": function(nRow, aData, iDisplayIndex, iDisplayIndexFull )     
  {
    $('td:eq(0)', nRow).hide();
  }
});

Updated. Try to add fnRowCallback. thanks!

edited Feb 9, 2015 at 0:37

answered Feb 9, 2015 at 0:10

Lumi Lu

3,3011 gold badge14 silver badges21 bronze badges

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

Comments

Pipo · Accepted Answer · 2017-06-07 09:38:41Z

1

I finally found another answere : it doesn't depends of html or json source but there is a difference between DataTable() which is the new version and dataTable() the old version

column(n).visible(bool)

works for DataTable()

fnRowCallback

works for dataTable()

edited Jun 7, 2017 at 9:38

answered Feb 18, 2015 at 23:52

Pipo

5,7718 gold badges37 silver badges71 bronze badges

Collectives™ on Stack Overflow

How to hide or show column of table created using datatables in javascript?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related