Search

Is this a duplicate question of your other post? https://datatables.net/forums/discussion/59861/how-to-reset-the-filters-using-a-button#latest Using fnFilter('') clears the search input here: http://live.datatables.net/jitafane/1/edit Please provide an example showing the issue so we can help debug. https://datatables.net/manual/tech-notes/10#How-to-provide-a-test-case Kevin

Thanks Kevin, Yes on Server Side Table it Use LIKE %Search Word% Is There any method so we can search same as on server side table?

for the input use search() to search the table

This example here is doing a range search on age - you could use that as a guide. Colin

Edit: Just ran a search and found that it doesn't look like there is much support for regex with server-side processing. Yes, that's the case. This thread should help, it's asking the same thing. Cheers, Colin

exemple, I need to search null value for "view_pa.pm_mesc_arcep_date".

know, before building the search box, if the field

to put parenthesis outside search kewords. $sql.=" AND ( u.username

Are you saying it is working now? The screenshot only shows me that you have a row with Mary. Is this after trying to search? Kevin

if you're using server-side search. I suppose that defeats