Search

Fantastic - great to hear that this worked! Allan

As a guess, I bet you are encountering a javascript error so the script stops executing. Open up your console (f12) and try reloading your page and see if any errors show up. Also, look at the raw html that your php is creating after the page is loaded and see if it looks right.

Thanks allan, will try to use it

Did you try: $('input').val('').change(); $(".yourtable").DataTable().search("").draw();

Hi Allan! Thanks for reply! I was working in the test case when I realize what's happening! The code that generate the input, was bubbling and generate more than one element, than, when the first element losts the focus, it triggers the blur event. I rewrite the code to avoid this and everything works perfect now! Thanks for your attention and for this amazing plugin!

https://datatables.net/reference/option/stateSave

Anyone any ideas ? TIA

single table for datatable: ~196,687 total records of all database: 2,333,990... Datatable is perfect tool for me. For this reason, I do not wanna use server-side pagination or another method. :neutral: I accepted MySQL bug for now. "SET NAMES utf8" method does not work for Turkish characters "ı", "ü", "ğ". I still have not found a solution :(

For complex client-side filtering you need to use a custom search plug-in. A UI for that is something I hope to introduce in future (although it will probably be next year). Regards, Allan

For complex queries that looks about as good as it gets :-) Allan