let's say we have a column which has telecommunication company names in it, so one of the values is "AT&T".
Global search fails to find any AT&T rows despite they exist in the table. Not necessarily a big problem in my use case, but also the column filter fails to return desired results here and this is not good at all.
I didn't test other methods like powerful filters yet, but I suspect the problem occurs in any search and filter.
Could you please conduct some tests and hopefully provide a fix or a workaround (replacing the brand as "ATT" is not an option). Thank you.
Our developers have identified the root of this bug,
that does not correctly render special characters such as the percentage sign for filtering in selectbox and/or multiselectbox filters.
Note that this bug only happens to non-server-side tables. It does not happen to server-side processing tables ( Manual tables and SQL Query tables with server-side enabled).
They are working on building a permanent fix for this,
but it is a very difficult bug, so it will take some time until they test everything to ensure that the new fix does not negatively affect any other plugin functionalities before they add it to the plugin's core.
They will do their best to make it as soon as possible, but i can't promise a realistic ETA on it.
You can certainly follow our changeLog page if you'd like ( it is also available in the plugin dashboard), where we state any changes/new features/bug fixes during updates;
and our newsletter, so you're informed about new features, bug fixes, freebies, etc.
We will make a patch Note about that fix there, when it is finished/added to the plugin core.
In the meantime, here is a temporary JS fix that you can copy to overwrite the file on your FTP in the plugin files.
( You can either use FTP or your Hosting's File Manager)
and please make sure to disable 'Use minified wpDataTables Javascript' in the main plugin settings/Custom JS and CSS:
Until our developers implement a fix to the plugin's core,
you would have to repeat this "overwrite" step each time you update the plugin.
This is not a perfect fix - It seems to be only working for SelectBox, but not for MultiSelectbox and it seems to work only for some specific characters, not for all of them, that is why it is still a work in progress.
Let me know if you apply this fix, if it works correctly for you, please.
2. Another workaround to avoid the bug, could be, if possible, for you to switch to server-side processing tables. It depends on which table type you use at the moment. For example, if you have the data on Excel/CSV/ or Google Sheet, you can import it to make a server-side/editable table.
Hello,
let's say we have a column which has telecommunication company names in it, so one of the values is "AT&T".
Global search fails to find any AT&T rows despite they exist in the table. Not necessarily a big problem in my use case, but also the column filter fails to return desired results here and this is not good at all.
I didn't test other methods like powerful filters yet, but I suspect the problem occurs in any search and filter.
Could you please conduct some tests and hopefully provide a fix or a workaround (replacing the brand as "ATT" is not an option). Thank you.
Kind regards, Alex
Hi Alex,
Our developers have identified the root of this bug,
that does not correctly render special characters such as the percentage sign for filtering in selectbox and/or multiselectbox filters.
Note that this bug only happens to non-server-side tables. It does not happen to server-side processing tables ( Manual tables and SQL Query tables with server-side enabled).
They are working on building a permanent fix for this,
but it is a very difficult bug, so it will take some time until they test everything to ensure that the new fix does not negatively affect any other plugin functionalities before they add it to the plugin's core.
They will do their best to make it as soon as possible, but i can't promise a realistic ETA on it.
You can certainly follow our changeLog page if you'd like ( it is also available in the plugin dashboard), where we state any changes/new features/bug fixes during updates;
and our newsletter, so you're informed about new features, bug fixes, freebies, etc.
We will make a patch Note about that fix there, when it is finished/added to the plugin core.
In the meantime, here is a temporary JS fix that you can copy to overwrite the file on your FTP in the plugin files.
( You can either use FTP or your Hosting's File Manager)
The path to overwrite the file should be :
../wp-content/plugins/wpdatatables/assets/js/wpdatatables/wdt.columnFilter.js
and please make sure to disable 'Use minified wpDataTables Javascript' in the main plugin settings/Custom JS and CSS:
Until our developers implement a fix to the plugin's core,
you would have to repeat this "overwrite" step each time you update the plugin.
This is not a perfect fix - It seems to be only working for SelectBox, but not for MultiSelectbox and it seems to work only for some specific characters, not for all of them, that is why it is still a work in progress.
Let me know if you apply this fix, if it works correctly for you, please.
2. Another workaround to avoid the bug, could be, if possible, for you to switch to server-side processing tables.
It depends on which table type you use at the moment.
For example, if you have the data on Excel/CSV/ or Google Sheet, you can import it to make a server-side/editable table.
Later on, you can edit this table from our Plugin and it can also be updated from file upload.
I hope that helps.
Thank you.
Attached files: wdt.columnFilter 6.1.zip
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
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