I have a data table set up with a column that includes string values from one of the following:
Region I
Region II
Region III
Region IV
Region V
Region VI
Region VII
Region VIII
Region IX
Region X
In the column set up, I have both specified the exact values in the "Possible values" field and set filter type to Select box.
Unfortunately the filter does not seem to be working properly - values from other regions show up for every filter selection except "Region IV" and "Region VIII" - my guess is because these are unique orders of "IV" and "VIII" that aren't in any of the other numbers.
The values are LONGTEXT from a MYSQL query, if that provides any useful information.
When i go to your link below it asks me to enter the credentials. (attachment)
So can you please provide me a temporary WP-admin login for your site where this happens, so we could log in and take a look ‘from the inside’ as that’s the most efficient way to see and resolve the issue. We do not interfere with any data or anything else except for the plugin (in case that’s a production version of the site), and of course we do not provide login data to third party. You can write credentials here just check Private Reply so nobody can see them except us.
I'm sorry but I can't give you access. I've mitigated the problem by renaming the options to integers instead of roman numerals, so the filter parameters are unique. Feel free to close this issue, but I figured I'd let you know about the issues w/ the jquery column filter plugin in case others are affected.
Hi there -
I have a data table set up with a column that includes string values from one of the following:
In the column set up, I have both specified the exact values in the "Possible values" field and set filter type to Select box.
Unfortunately the filter does not seem to be working properly - values from other regions show up for every filter selection except "Region IV" and "Region VIII" - my guess is because these are unique orders of "IV" and "VIII" that aren't in any of the other numbers.
The values are LONGTEXT from a MYSQL query, if that provides any useful information.
Thanks!
Hi trusa,
Thank you for your purchase.
Can you please send me the link of that table so I can take a look.
Best regards.
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
Hi trusa,
When i go to your link below it asks me to enter the credentials. (attachment)
So can you please provide me a temporary WP-admin login for your site where this happens, so we could log in and take a look ‘from the inside’ as that’s the most efficient way to see and resolve the issue. We do not interfere with any data or anything else except for the plugin (in case that’s a production version of the site), and of course we do not provide login data to third party. You can write credentials here just check Private Reply so nobody can see them except us.
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
Hi trusa,
I do not have permissions to edit the plugin but I will write you guide here so you can change the code.
In file ../wp-content/plugins/wpdatatables/source/class.wpdatatable.php search for
and replace it with
Let me know the result.
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
Unfortunately that didn't work - the table isn't using server-side rendering, so I think it's related to the jQuery dataTables implementation?
Thanks!
Actually it looks like an issue with the jquery-datatables-column-filter plugin - there's quite a number of open issues, and it looks like the plugin hasn't been updated in a few years: https://code.google.com/archive/p/jquery-datatables-column-filter/issues
It looks like jquery dataTables supports select filtering via the api, so maybe there's a solution there? https://datatables.net/examples/api/multi_filter_select.html
Hi trusa,
Can you please give me permissions to edit the plugin so I can take a look at the code.
Thank you.
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
I'm sorry but I can't give you access. I've mitigated the problem by renaming the options to integers instead of roman numerals, so the filter parameters are unique. Feel free to close this issue, but I figured I'd let you know about the issues w/ the jquery column filter plugin in case others are affected.
Thanks!