Search

am looking for exact filter the record of only

Hi @Sh_Si , You would need to create a custom search filter for this. This one here is similar and could be used as a template - it's for phone numbers, but it matches multiple ways of searching. Cheers, Colin

Here is a working example of the bootstrap datepicker used as a datatables date filter, hope it helps https://jsfiddle.net/bindrid/2bkbx2y3/6/ Colin

option to pass the filter to the server script

searchCols": [ null, { "search": "My filter" }, null, { "search": "^[0-9]", "escapeRegex":

pmgListTable.column(2).search('').draw(); Won't filter. Correct, that is the

But what if i want the filter to actually affect the display?

Your description doesn't explain what you are expecting. The filter() API is a client side method. The filteredData variable will contain the values found that are greater than 100. Checkout this example: http://live.datatables.net/suyirugi/1/edit What are you expecting/wanting to happen? Kevin

To take @colin's solution a bit further you could use filter() and count() in the search event for the hidden columns. If the count is greater then 0 then display the column. Kevin

Are you asking about filtering or sorting? In either