Search

Yes - the demo script on this site will use a LIKE statement with wildcards. As tangerine highlights, you'd need to modify whatever server-side script you are using since you are using server-side processing. Allan

As a guess, I bet you are encountering a javascript error so the script stops executing. Open up your console (f12) and try reloading your page and see if any errors show up. Also, look at the raw html that your php is creating after the page is loaded and see if it looks right.

Hi, I'm new to datatables, I had a simular problem, the code below solved my problem. I call it before applying the filter, it updates the datatable based on the current html. if you are using ajax data try "table.ajax.reload();" instead. [code] table .rows() .invalidate() .draw(); [/code] Hope this helps, Cheers Patrick

Try configuring your DataTable with the following options: ajax, make sure and read the "Related" section deferRender

Also can I get the data of the currently selected row? Yes - see the select API integration documentation. Allan

thanks

I found a work around that worked for us. I just reused the column.search() function once the table was ready. Hope this helps var lastCat = 'the category'; var table = $('#Products').DataTable({ "iDisplayLength": 40, initComplete: function () { this.api().columns('3').every( function () { var column = this; var select = $('<select><option value="">All Categories</option></select>') .appendTo( $(column.footer()).empty() ) .on( 'change', function () { var val = $.fn.dataTable.util.escapeRegex( $(this).val() ); column.search( val ? '^'+val+'$' : '', true, false ).draw(); } ); column.data().unique().sort().each( function ( d, j ) { if(lastCat === d) { select.append( '<option SELECTED value="'+d+'">'+d+'</option>' ) } else { select.append( '<option value="'+d+'">'+d+'</option>' ) } } ); $(table).ready(function() { column.search( lastCat ? '^'+lastCat+'$' : '', true, false ).draw(); }); } ); } });

You would need to implement a custom filtering plug-in for this. The built in "smart" filtering won't do that I'm afraid. Allan

Thanks for your question - however, per the forum rules can you link to a test case showing the issue please. This will allow the issue to be debugged. Information on how to create a test page, if you can't provide a link to your own page can be found here. Thanks, Allan

This isn't a DataTables issue, but rather a Bootstrap one. As you note, if you remove Bootstrap the issue goes away. By default Bootstrap 3 removes the clear icon. Allan