Jquery Datatable Editor Serverside processing: Col filters doesnt work withmultiple where conditions

mlowrey

Greetings,

Whenever I use multiple where conditions, the column filtering doesnt work. If i only have 1 where condition it works fine. Why? Any ideas on how i can fix this?

Where's the where condition:

    ->where( function ( $q ) {
                $q->where( 'rep', 'Mike Lowrey );
                $q->or_where( function ( $r ) {
                        $r->where( 'manager', 'Mike Lowrey' );
                        $r->or_where( function ( $s ) {
                                $s->where( 'regional', 'Lowrey' );
                            });
                    });
            })

Footer Column Filtering

<script>
$(document).ready(function() {
$('#example tfoot th').each( function () {
        var title = $(this).text();
        $(this).html( '<input type="text" placeholder="Search '+title+'" />' );
    } );
    } );
</script>