Breaking News: Grepper is joining You.com. Read the official announcement!

how to filter on a hidden column datatables

Victorious Vole answered on March 31, 2021 Popularity 7/10 Helpfulness 1/10

answer how to filter on a hidden column datatables

how to filter on a hidden column datatables

Comment

Plain text12345678910111213141516171819202122232425262728293031323334353637383940414243444546$(document).ready( function () {    $('#example').DataTable(    {                 responsive: true,        scrollY:'40vh',        scrollCollapse: true,        columnDefs: [        { targets: [0, 3, 4, 5, 7, 8, 9, 11, 12], visible: true},        { targets: '_all', visible: false },                 { width: "40%", targets: [5] }    ],                          "order": [[ 0, "asc" ]],        rowGroup: {                         enable: true,            dataSrc: 1,        },         initComplete: function () {            this.api().columns([1]).every(function () {                var column = this;                var select = $('<select><option value=""></option></select>')                    .appendTo( $(column.footer()).empty() )                    .on( 'change', function () {                        var val = $.fn.dataTable.util.escapeRegex(                            $(this).val()                        );                          column                            .search( val ? '^'+val+'$' : '', true, false )                            .draw();                    } );                  column.data().unique().sort().each( function ( d, j ) {                    select.append( '<option value="'+d+'">'+d+'</option>' )                } );            } );        }}         );     } );

Popularity 7/10 Helpfulness 1/10 Language javascript

Source: datatables.net

Tags: datatables filter hidden javascript

Link to this answer
Share Copy Link

Contributed on Mar 31 2021

Victorious Vole

0 Answers Avg Quality 2/10

how to filter on a hidden column datatables

Contents

More Related Answers

how to filter on a hidden column datatables

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.