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!
Hi,
I just bought wpDataTables. My objective is simple : generate a table of posts for only one category.
I just made a fresh install of wordpress and install the plugin.
I follow the tutorial "Create a MySQL-query-based table by generating a query to WordPress database".
So it works if I ask to have all posts.
But if I add a condition "post.taxonomy.category" = "name or id of my category", it doesn't work.
I try LIKE instead =, I try to put the ID, I always have the message "No results found."
I try to create a custom field with value = 1 and I add a condition with this custom field... same thing, no results.
So, my question is:
How we could generate a table of posts filtered by category and/or with a custom field?
I understand that complex sql querie can't be generated by the plugin, but what I ask seems to be very easy and I will be surprised if the plugin by default can't do this... but certainly I don't to the right thing.
Thank you for help me,
Best regards,
Emmanuel
HI Emmanuel,
Thank you for your purchase.
When you have some complex queries our suggestion is to make a VIEW in phpmyadmin or any other database management system and see if it will return the desired result.
If the result is good, use that query as an input when creating tables from Add from data source option.
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,
Thank you for your answer.
I don't think my ask is a complex query.
I just made a fresh install of wordpress and a fresh install of plugins.
And I just want to generate a table with posts from only one category.
It seems that it's not working... on fresh install and without any modifications, that's why I'm a little surprised because it's a easy logic and I'm a beginner on sql, that's why I would like to use this plugin in order to generate a table without made code (but I understand that it's necessary for complex query).
Could you check and tell me if you have a correct procedure to do what I need?
Thanks agains,
Best regards
HI Emmanuel,
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.
Also give me some directions or guide so I can try to reproduce your issue.
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 Emmanuel,
When I make a query following your steps below without condition I get this result. ( attachment)
I think the issue might be because the query can not find the second-category
Can you please tell me did you try to make a VIEW in some database management system.
Also please note from our documentation this notice
Please note that this tool is not an ultimate query generator, it just constructs a suggestion of a query. We constantly work on improving it, but SQL is such a complicated and flexible language that full automation for constructing queries is hardly possible. So the more complicated the query is, the higher is the chance that it will not return exactly what you need. So play around with the resulting query.
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 Emmanuel,
It looks like this issue is on our side. We investigated the issue and it looks like we will need to update this problem with post types and taxonomies and find the proper solution.
Thank you for reporting this, we are working on finding the solution and release it with our new update of the plugin.
Sorry for any inconvenience and thank you for understanding.
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