Search

"searchCols" is correct for 1.10 +. http://datatables.net/reference/option/searchCols

Thanks for your reply. I did try your suggestion but unfortunately the dropdown boxes also contain values from all of the other tables in the page. I think the problem has something to do with the table variable referring to all of the tables rather than just the one being rendered. This is my code. Do you have any further ideas? $(document).ready(function () { var table = $('.filterableTable').DataTable(); $(".filterableTable thead th").each(function (i) { if ($(this).hasClass('filter')) { console.log(i); var select = $('<select><option value="">All</option></select>') .appendTo($(this)) .on('change', function () { var val = $(this).val(); table.column(i) .search(val ? '^' + $(this).val() + '$' : val, true, false) .draw(); }); table.column(i).data().unique().sort().each(function (d, j) { select.append('<option value="' + d + '">' + d + '</option>') }); } }); }); Edit Fixed it: $(document).ready(function () { $.each($('.filterableTable'), function () { $(this).find('thead th').each(function (i) { if ($(this).hasClass('filter')) { var currentTable = $(this).closest('.filterableTable').DataTable(); var select = $('<select><option value="">All</option></select>') .appendTo($(this)) .on('change', function () { var val = $(this).val(); currentTable.column(i) .search(val ? '^' + $(this).val() + '$' : val, true, false) .draw(); }); currentTable.column(i).data().unique().sort().each(function (d, j) { select.append('<option value="' + d + '">' + d + '</option>') }); } }); }) });

I resolved my issue. I had to add footer to my gridview :). Thank you anyway.

output of fnCreateSelect(oTable.fnGetColumnData(i))   N040062F N0400559 N04005CF N0400665 N0400507 N04005B1 N04005B0 N040068B N04005AE N0400381 N0400308 N0400331 N0400542 N04004EB N0400532 N0400672 N040028D N0400630 N0400563 N0400515 N0400453 N040040E

do it :-) The select filters only show data from

No it doesn't. I don't know why it is matching it on your English row - it must appear somewhere in the row's data. We'd need to see it to know why for sure. Allan

I don't really understand - what comma separated columns? DataTables doesn't use comma separation for columns (except TableTools' CSV export I suppose). Allan

Since you're using Java you might want to consider using JED along with DataTables to display your data. Check out: http://jed-datatables.ca/jed/

Since you're using Java you might want to consider using JED along with DataTables to display your data. Check out: http://jed-datatables.ca/jed/

Allan, Any luck with this one?