Search

Hi Allan, I am just tried keytable new version. It is working perfectly now. I am sorry that I am too late to let you know. Thank you very much. Toki

Upper/Lower case is not an artistic decision, you need to use the right one. :) The difference is described here, http://datatables.net/manual/api Compare your code to the example. http://datatables.net/examples/api/multi_filter.html

I had the same issue and could eventually work it out, using the columns.render property. See https://datatables.net/reference/option/columns.render and especially the 2nd example there.

thxxxxxx guys

Thanks tangerine, I figured out the issue. searching: false was definitely the first issue. The other was that I was using scrollx and still trying to append to my default table. Changing my second instance of #mytable on line 7 to .dataTables_scrollHead was the second thing that fixed my problem.

"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