Search

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

I don't see any reason why not. Just pass it in like you would do for any function you define? Allan

Sounds like you are using server-side processing in which case you would have to do the regex filtering on the server-side. Thanks Tom

Hi, Nicely done. I think the only other way of doing it currently would be to modify the DOM with a little bit of jQuery after the table has been created, which would also be valid. A plug-in could be used to see the init event and perform that action automatically. Allan