jQuery DataTables - Filter column by exact match
Solution 1:
This will give you exact result for a column.
table.column(i)
.search("^" + $(this).val() + "$", true, false, true)
.draw();
ie . search( input , regex, smart , caseInsen )
Solution 2:
Ok solved the problem. However, since the column I am using the exact match on sometimes contains multiple ID #s seperated by commas, I wont be able to use an exact match search.
But for those interested, here is the answer:
oTable.fnFilter( "^"+TERM+"$", COLUMN , true); //Term, Column #, RegExp Filter