How to show and hide columns in datatable.js without AJAX request?

Question

How can I show and hide columns in datatable.js you see I can enable and disable it BUT the problem is my datable is binded in AJAX source so it automates requests each time I show and hide a column.

Below is the code I used but has no luck in showing and displaying columns without an ajax request.

$(".table-dash1").dataTable().fnSetColumnVis(0, false);

Milan Stojanovic · Accepted Answer · 2014-03-21 10:28:35Z

1

An example from the DataTables documentation:

$(document).ready(function() {
    $('#example').dataTable( {
        "sScrollY": "200px",
        "bPaginate": false
    } );
} );

function fnShowHide( iCol )
{
    /* Get the DataTables object again - this is not a recreation, just a get of the object */
    var oTable = $('#example').dataTable();



    var bVis = oTable.fnSettings().aoColumns[iCol].bVisible;
    oTable.fnSetColumnVis( iCol, bVis ? false : true );
}

Hope this helps.

answered Mar 21, 2014 at 10:28

Milan Stojanovic

3071 silver badge14 bronze badges

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

1 Comment

Dee Jay Over a year ago

Great answer, especially since I can't find the solution for version under 1.10. Cheers!

Collectives™ on Stack Overflow

How to show and hide columns in datatable.js without AJAX request?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related