I'm using an SQL query as my data source and the advanced filtering mode.
The issue I’m facing is that when I apply a filter to any column, I initially see the correct results, but immediately after, the refresh occurs and all filtering is removed.
Thank you for this confirmation, I will advise our devs to be aware that this detail should be added to the description of the bug for Fixed headers.
I will show you a way if you wish to apply this fix right away. Or if not - you can wait for our official update with the Fixed headers fix.
This is a bug that started with our wpDataTables 7.0 version and continued through 7.0.1 and the new 7.1. Our developers created the first version of the fix, which we tested on multiple Test Sites. So far, it is working well, so you can try applying it to your Site. I am sending the JS fix file here as an attachment.
Here are the instructions to apply it. Please find this JS file in our Plugin files on your WordPress hosting Plugins folder via FTP or your Hosting File Manager ( or you can try installing a Plugin "File manager" and do it this way) in the path :
Extract the JS fix we sent from the zipped folder, and upload it to overwrite the existing file.
In the end, make sure to disable this option in the Main Plugin settings/Custom JS and CSS/'Use minified wpDataTables Javascript' for this JS fix to work on the front end.
We advise purging the cache of the Site after a major change like this, to be safe.
I recorded a Video, just to demonstrate the 'before' and 'after' difference on one of my Tables via wpDataTables 7.1 version and the steps to apply the fix.
You can see, before the fix, if I scroll down to a certain point - the table starts flashing in a weird way and the layout gets messed up, along with other issues etc;
Then after the fix, the issue stops happening and we can use the Fixed Headers again with our new 7.1 version.
If you need us to apply it for you, please send me the URL of a Page on your Site with the Table; And we need Administrator User credentials for the Site; Along with FTP credentials - and confirm the WordPress Folder path on this FTP for the Site - we don't wish to edit anything for the wrong site.
You can send the credentials here, just make sure to send the reply as PRIVATE - so only we can see it.
Let me know how it goes if you apply this fix - it should work.
Just also make sure to first update your wpDataTables to the new 7.1 version, before you start applying this fix - or if you need us to apply it, as well.
2. In regards to editing the filter label - we have this option for each column, you can set it up in the Column settings/Filtering/Filter label :
Hello,
I'm using an SQL query as my data source and the advanced filtering mode.
The issue I’m facing is that when I apply a filter to any column, I initially see the correct results, but immediately after, the refresh occurs and all filtering is removed.
NOTE: Auto-refresh is disabled.
Hi
Thank you for a qucik reply. Actually I'm already using MySql view.
But solution 2 fixed the problem - disabling "Fixed headers" has resolved the issue.
But I've got another small issue. Is ther anyway to translate filtering options when using enum ? (see screenshot)
Attached files: FIltering.png
Hi Mateusz,
I will show you a way if you wish to apply this fix right away. Or if not - you can wait for our official update with the Fixed headers fix.
This is a bug that started with our wpDataTables 7.0 version and continued through 7.0.1 and the new 7.1.
Our developers created the first version of the fix, which we tested on multiple Test Sites. So far, it is working well, so you can try applying it to your Site.
I am sending the JS fix file here as an attachment.
Here are the instructions to apply it.
Please find this JS file in our Plugin files on your WordPress hosting Plugins folder via FTP or your Hosting File Manager ( or you can try installing a Plugin "File manager" and do it this way) in the path :
..\wp-content\plugins\wpdatatables\assets\js\wpdatatables\wpdatatables.js
Extract the JS fix we sent from the zipped folder, and upload it to overwrite the existing file.
In the end, make sure to disable this option in the Main Plugin settings/Custom JS and CSS/'Use minified wpDataTables Javascript' for this JS fix to work on the front end.
We advise purging the cache of the Site after a major change like this, to be safe.
I recorded a Video, just to demonstrate the 'before' and 'after' difference on one of my Tables via wpDataTables 7.1 version and the steps to apply the fix.
You can see, before the fix, if I scroll down to a certain point - the table starts flashing in a weird way and the layout gets messed up, along with other issues etc;
Then after the fix, the issue stops happening and we can use the Fixed Headers again with our new 7.1 version.
If you need us to apply it for you, please send me the URL of a Page on your Site with the Table;
And we need Administrator User credentials for the Site;
Along with FTP credentials - and confirm the WordPress Folder path on this FTP for the Site - we don't wish to edit anything for the wrong site.
You can send the credentials here, just make sure to send the reply as PRIVATE - so only we can see it.
Let me know how it goes if you apply this fix - it should work.
Just also make sure to first update your wpDataTables to the new 7.1 version, before you start applying this fix - or if you need us to apply it, as well.
2. In regards to editing the filter label - we have this option for each column, you can set it up in the Column settings/Filtering/Filter label :
Let me know how it goes.
Attached files: wpdatatables.js.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