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.
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?
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.
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