We're Moving to a New Support Platform – Starting June 1st!
We’re excited to let you know that starting June 1st, we’ll be transitioning to a new support system that will be available directly on our product websites – Amelia, wpDataTables, and Report Builder. In fact, the new support platform is already live for Amelia and wpDataTables, and we encourage you to reach out to us there.
You'll always be able to reach us through a widget in the bottom right corner of each website, where you can ask questions, report issues, or simply get assistance.
While we still do not offer live support, a new advanced, AI-powered assistant, trained on our documentation, use cases, and real conversations with our team, is there to help with basic to intermediate questions in no time.
We're doing our best to make this transition smooth and hassle-free. After June 1st, this current support website will redirect you to the new "Contact Us" pages on our product sites.
Thanks for your continued support and trust – we’re excited to bring you an even better support experience!
Hello!
I'm using WpDatatables in connection with a MySql database.
When I search in a column for two keywords A and B like this
A B
then only rows are returned which match exactly the string A B.
What I want, however is to get all rows which contain A and B regardless of their order and distance.
Do I have to reconfigure my MySql-Index or is this possible with WpDatatables?
Thanks,
Julius
Hello Julius
I am sorry to disappoint you, but unfortunately something like this is not possible with the plugin's built-in features.
The search is only looking for existing strings in the table. If A and B are next to each other they will be found like that. Finding all instances of both is not possible.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
Hm, okay.
Then I have another issue using MySQL and server side processing:
Basically, the MySql table is loading fast and the checkboxes function fast too.
But always when I type in a term in the search box for a particular column it slows down rapidly. When I have 10 000 rows a search query needs 7-12 seconds on average. But when I use the mere search-box covering the full table, speed is fine (3-4 seconds). Cascade filtering is also activated. Nonetheless, this seems strange, because the search box includes more than one column.
The column, in which the search should be executed, has already a fulltext Index. Additionally I'm using the MyISAM-Engine.
Do you have any ideas, how to make the search in a particular column faster?
Thanks in advance,
Julius
Hello Julius
Unfortunately, there's nothing you can do to speed up search inside a filter of a column. A server-side table fetches only those rows needed on the page at the exact moment, so when you're searching through a filter, the plugin goes through all possible values in the table, and retrieves the result.
Global search works faster, yes, but the query behind filter is a bit more complex, and it filters the table per column first, and then it tries to find what you're typing in based on results of the previous filter, while the Search filter only searches through the entire table.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables