Search

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

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