Individual column searching (select inputs) with Ajax

pvtpepper

Trying to get this code:

<script>
   jQuery(function(){
        jQuery('#datatable').dataTable({
            "ajax": "/sites/sample.json",
 
"columns": [
                { "data": "region" },
                { "data": "state" },
                { "data": "siteId" },
                { "data": "siteName" },               
            ],
"lengthMenu": [[10, 25, 100, -1], [10, 25, 100, "All"]]
 
    } );
} );
  
 </script>

To work with this:
https://datatables.net/examples/api/multi_filter_select.html

but getting stuck on where to insert it.

Thanks!

aaronw

You would insert the "ajax", "columns", and "lengthMenu" options (everything in "" or [] after those options) right before initComplete

pvtpepper

Like this?

$(document).ready(function() {
    $('#dataTable').DataTable( {
        "ajax": "/sites/sample.json",
  
"columns": [
                { "data": "region" },
                { "data": "state" },
                { "data": "siteId" },
                { "data": "siteName" },              
            ],
"lengthMenu": [[10, 25, 100, -1], [10, 25, 100, "All"]],

        initComplete: function () {
            this.api().columns().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>' )
                } );
            } );
        }
    } );
} );