Datatables with rowGrouping cannot hide columns

Question

JS:

$(document).ready(function() { // $( "#dashboard_container" ).tabs(); $('#listings').dataTable({ "bRetrieve": true, "aoColumns": [ { "bVisible": false }, { "bVisible": false }, { "bVisible": false }, { "bVisible": false }, { "bVisible": false }, { "bVisible": false }, { "bVisible": false }, { "bVisible": false }, { "bVisible": false }, ] }).rowGrouping({ iGroupingColumnIndex: 1, sGroupingColumnSortDirection: "asc", iGroupingOrderByColumnIndex: 0, bExpandableGrouping: true, bExpandSingleGroup: true, iExpandGroupOffset: -1 }); }); 

HTML:

  <table class="datatable" id="listings"> <thead> <tr> <th>Group Index</th><th>Group Display Name</th> <th>Organization</th> <th>Volumes</th> <th>Read (MB/s)</th> <th>Write (MB/s)</th> <th>Volume Size (GB)</th> <th>My Cost (USD)</th> <th>Comments</th> </tr> </thead> <tfoot></tfoot> <tbody> <tr> <td>0</td><td><a href="/dashboard/" class="orglist_group_link">Artful Scientific</a></td> <td>Something Co.</td> <td><a href="/details/view?volume=12345678" class="orglist_link">information</a></td> <td>0</td> <td>0</td> <td>0</td> <td>$0</td> <td><a class="btn small icon i_preview comment_edit_button" rel="1" title="edit or view comment">View</a></td> </tr> </tbody> </table> </div> 

Problem:

I can successfully perform row groupings and it works fine, however I need it when I need to hide 2 columns for specific roles. As well as hiding the extra column, which will be the equivalent of the Organization column that the grouping uses. However, from the above JS, you can see that I tried to hide all the columns to see if anyone was really hiding in my last stress before coming here. No matter which of them or no one will hide. Does anyone know about this? Since I need the columns to remain, but hidden from the actual view

Answer 1

Hide the column using this command, and the first parameter is the column index and the second parameter is visibilty

fnSetColumnVis (1, false);