Search

well. For example, I search record by "big group"

Probably the easiest option is to move the total to the footer like this example: https://datatables.net/examples/advanced_init/footer_callback.html Otherwise you will probably need to create a search plugin to not include that row. https://datatables.net/manual/plug-ins/search Kevin

Do a search on scss or "sassy css", it will help you understand what is going on.

DataTables uses the terminology search for user input values

i use for the search SELECT DOS.NR_PAT Patient, PAT.FNAAM_PAT||'

oTable = $('#example').dataTable({ "oLanguage": { "sSearch": "Search all columns:" }, "aoColumnDefs": [{ 'bSortable':

Hello Allan, I have figured out the problem. It was simple using: $data->where( function ( $q ) { $q->or_where('MiddleName.NAME', 'joe' ); $q->or_where( 'MiddleName.NAME', 'Dad' ); }); now i get all the benefits of binding plus multiple search terms in one go. Thanks for your help.

following: //1. number of search parms (0 - 4) //2.

Yes, with the columns render function, you can make it look how ever you want https://datatables.net/reference/option/columns.render If you put render in the search box, there are lots of examples.

assuming the checkboxes are not in the datatable, You would use the click event handler on the checkbox to apply a search that is represented by the checkbox on the for example $(checkbox).on("click", function() { if( this.checked) { $("#example").DataTable().search(this.value).draw(); } });