Search

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

Check out https://github.com/vedmack/yadcf

any help?

It should be possible to define a global search parameter using search.search and for column search using searchCols. Allan

The expected out should be that if i search for 5000 it should match the row that contains 5 000