Enable disable fixed column in DataTable using a button

Question

Myself created a html table with fixed columns using jquery DataTable with reference to This example as,

$(document).ready(function() {
    var table = $('#example').DataTable( {
        scrollY:        "300px",
        scrollX:        true,
        scrollCollapse: true,
        paging:         false
    } );
    new $.fn.dataTable.FixedColumns( table, {
        leftColumns: 2
    } );
} );

UPDATE: Myself trying to enable/disable the fixed column using a button as given in this fiddle as,

var columnNumber = 2;
  $('#ToggleColumns').click(function () { 
  if(columnNumber == 2)
  {
columnNumber = 0;  
  }
  else {
  columnNumber = 2; 
  }
foo();

where the foo() contains the columnNumber to be fixed. What is the correct syntax to toggle the column number based on the button?

enable or disable in what context.. they should not behave as a fixed column after disabling and vice verca ? — Ankush Jain
– Ankush Jain, Commented Aug 14, 2014 at 5:28
Myself want to enable fixed column feature in some cases. In other conditions it should be disabled using a button click. Again, it should be enabled if the user click the button again and vice versa. — mpsbhat
– mpsbhat, Commented Aug 14, 2014 at 5:37

mpsbhat · Accepted Answer · 2014-09-15 05:54:21Z

1

It is solved by using table.destroy(); method of datatable and initializing new options with new columnNumber.

Sample Link: http://jsfiddle.net/eqsadgez/1/

Please suggest if any better ways.

edited Sep 15, 2014 at 5:54

answered Aug 16, 2014 at 4:08

mpsbhat

2,77312 gold badges52 silver badges107 bronze badges

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

Comments

BPT · Accepted Answer · 2014-08-14 05:50:46Z

0

I think all you can do is add or remove "sorting" class on each click

answered Aug 14, 2014 at 5:50

BPT

364 bronze badges

Comments

Mahesh Dama · Accepted Answer · 2020-06-12 12:06:07Z

0

For me, it worked.

$(".DTFC_Cloned").addClass('d-none');

.DTFC_Cloned is a class datatables gives to a cloned table with fixed column data.

answered Jun 12, 2020 at 12:06

Mahesh Dama

1136 bronze badges

Collectives™ on Stack Overflow

Enable disable fixed column in DataTable using a button

3 Answers 3

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related