Search

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

Argh. never mind, had 2 tags. Removed the bad one, all is good.

For those interested, here is a solution http://stackoverflow.com/a/36274599/615379

A workaround I'm using right now is to build a filter string with pipe character (regex or) table.column(2).search('Tokyo|New York', true, false).draw();

could you please be specific. or provide a screenshot.