jQuery Datatable filter hidden column by dropbox does not work

Question

http://live.datatables.net/wifezuru/2/edit 15th column is hidden and value is false/true. When select (left top corner) shipping status from there it must filter DataTable by true/false value of the 15th column. Table works fine but that filter is not working. I mean does not show anything.

Also I tested with

$('#zctb').DataTable().columns(9).search('Sheridan-Sept2022').draw();

it works fine but

$('#zctb').DataTable().columns(15).search('true').draw()

; does not show result.

$("#zctb").DataTable({
        "responsive": true,
        "bAutoWidth": true,
        scrollX: true,
        // execute callback when DataTable is completely initialiazed
        "initComplete": function () {
            // Select the column whose header we need replaced using its index(0 based)
            this.api().column(2).every(function () {
                var column = this;
                // Put the HTML of the ')
                    // remove all content from this column's header and
                    // append the above  filter
                    .on('change', function () {
                        // escape special characters for DataTable to perform search
                        var val = $.fn.dataTable.util.escapeRegex(
                            $(this).val()
                        );
                        // Perform the search with the  filter with unique values from the column's data
                column.data().unique().sort().each(function (d, j) {
                    select.append("");
                });
            });
            this.api().column(9).every(function () {
                var column = this;
                // Put the HTML of the ')
                    // remove all content from this column's header and
                    // append the above  filter
                    .on('change', function () {
                        // escape special characters for DataTable to perform search
                        var val = $.fn.dataTable.util.escapeRegex(
                            $(this).val()
                        );
                        console.log('folder val ' + val);
                        // Perform the search with the  filter with unique values from the column's data
                column.data().unique().sort().each(function (d, j) {
                    select.append("");
                });
            });
            // this.api().column(8).every(function () {
            //     var column = this;
            //     // Put the HTML of the    ')
            //         // remove all content from this column's header and
            //         // append the above  filter
            //         .on('change', function () {
            //             // escape special characters for DataTable to perform search
            //             var val = $.fn.dataTable.util.escapeRegex(
            //                 $(this).val()
            //             );
            //
            //             // Perform the search with the  filter with unique values from the column's data
            //     column.data().unique().sort().each(function (d, j) {
            //         select.append("")
            //     });
            // });
        },
        // disable sorting on the column with the filter in its header.
        "columnDefs": [
            {
                "targets": 15,

                //if searchable enabled, FilterBannedPeople won't work
                //if searchable disabled, global search will search hidden column
                "searchable": false
            }

        ]
    });
    $.fn.dataTable.tables({visible: true, api: true}).columns.adjust();
    $.fn.dataTable.ext.search.push(
        function (settings, searchData, index, rowData, counter) {
            var searchVal = $('#bannedFilter').val();

            // Show all rows if select is emptry - 'all'
            if (searchVal === '') {
                return true;
            }

            // Show only rows that match the select value
            if (searchVal === rowData[15]) {
                return true;
            }

            // Filter row if it doesn't match.
            return false;
        }
    );

function FilterBannedPeople(bannedFilterDropDown) {

    var datatableObj = $('#zctb').DataTable();
    var searchVal = $(bannedFilterDropDown).val();
    var colIndex = 15;
    console.log(datatableObj.columns(colIndex).search(searchVal).draw());
    datatableObj.columns(colIndex).search(searchVal).draw();

}



  
    

    
    

    
    DataTables - JS Bin
  
  
    
                            
                            
                                                                Show  entries
Search:

                                    # Customer Name User Tiny URL Full URL SO WO PO Shipped? Folder Scan Count Download QR Image Created Date Action Action
                                    

                                    

                                    # Customer Name User Tiny URL Full URL SO WO PO Shipped? Folder Scan Count Download QR Image Created Date Action Action
                                    

                                    
                                    

                                    

                                                                                
                                                                                        
                                            
                                    
                                                1
                                                Sheridan
                                                hello@gmail.com
                                                17aca
                                                dropbox
                                                SO4564
                                                wo345435
                                                po345345
                                                
                                                    
                                                
                                                Sheridan-Sept2022
                                                7
                                                
                                                
                                                
                                                
                                                Download
                                                    

                                                
                                                
                                                2022-09-19 15:56:16
                                                
                                                        
                                                                                                              
                                                        
                                                
                                                
                                                    true                                                
                                            

                                                2
                                                Franklin Labs
                                                hello1@gmail.com
                                                0f354
                                                dropbox2
                                                SO6237
                                                
                                                117-254-417375198864
                                                
                                                    
                                                
                                                Office Resource-Boston
                                                4
                                                
                                                
                                                
                                                
                                                Download
                                                    

                                                
                                                
                                                2022-09-12 10:41:56
                                                
                                                        
                                                                                                              
                                                        
                                                
                                                
                                                    false                                                
                                            
                                
Showing 1 to 2 of 2 entries
Previous
1
Next

jQuery Datatable filter hidden column by dropbox does not work

0 Answers