Update Select filters as per the genrated table.
Update Select filters as per the genrated table.
Hi,
am using Datatables 1.10
When i select a filter in my Datatable , I am trying to update my filters as per the result set which is generated.
Here is my code.
table = $('#example').DataTable({
        "bSort": false,
 "fnRowCallback": function (nRow, aData, iDisplayIndex, iDisplayIndexFull) {
    $("#example thead td ").each( function ( i ) {
        if(i>1)
         select = $('<select class="form-control"><option value=""></option></select>')
            .appendTo( $(this).empty() )
            .on( 'change', function () {
                table.column( i )
                    .search( $(this).val() )
                    .draw();
            }
                 );
    table.column( i ).data().unique().sort().each( function ( d, j ) {
            if(i>1&&d!==""){
                select.append( '<option value="'+d+'">'+d+'</option>' )
            }
    } );
} );
}
});
table.column( i ).data().unique().sort().each( function ( d, j );
What i am trying to do in above code is to add dropdown filter code in the callback of datatable function.
So that when each time the datatable runs i should get the new filters.
Is there any option in datatable to do this?