Search

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(); } });

css change to remove Search and pagination for internal

In the above image I want to filter table on behalf of Id, question, handsUp,date when search button click. only data appear which fulfill the condition. Any help will be appreciated.

When I add or edit a record the search filter display name but when I select I get Id instead name Pic.

Now you're deleting the search values after drawing and

selects. This is a search page to find system