Search

the state of the table is not saving for the first search operation ,but from second time search operation is done the state of the datatable is getting saved.

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