Search

Searching as in using the global DataTables filter? If so, then the data would need to be included in hidden columns as the child rows have no effect on the table filtering. Allan

Here's my entire script: <script type="text/javascript"> $(document).ready(function () { var table = $('#tblForecast').DataTable({ "sPaginationType": "full_numbers", "bJQueryUI": true, "fnDrawCallback": calculateTotal, "bPaginate": true, "iDisplayLength": 100 }); //end table init $('#monthFilter').change(function () { var name = $("#monthFilter option:selected").text(); if (name !== "No Filter") { table.column(7).search(name).draw(); } else { table.column(7).search("").draw(); } }); //end change });//end ready </script>

not sure. static function filter ( $request, $columns, &$bindings ) { $globalSearch

No I couldn't make that work. Mind you the multi filter select example is flawed anyway - once a selection has been made, setting it back to nothing does not restore the full table.

This is a column filter control, or an external

Subject found for this filter", "sSearch": "Filter:" } }); var oTableDest

than in DataTables. The filter does run, but the

sent to the custom filtering function: source. Of particular

got it working by adding this $("#example tfoot input").on( 'keyup change', function () { table.draw(); index = $(this).parent().index(); filter = this.value.replace(/\s*/g, ''); opt = filter.match(/^(<|>)?(\w*|\d*)?/)[1]; num = filter.match(/^(<|>)?(\w*|\d*)?/)[2]; if(typeof opt === "undefined") { console.log("opt"); table .column($(this).parent().index() + ':visible') .search(this.value) .draw(); } });

the rows().data() method - table.rows( { filter: 'applied' } ).data() for example.