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!
I sent this question two days ago. How long is your response time?
I am thinking about buying wpdatatables but I get a bit afraid, if you do not even answer a pre-purchase question
Hello there
I am trying to perform some SQL but I'm not good at it, I am still learning basic skills, so my SEO-project has stopped, because I can not find the posts I want to work on. And my site is huge (1.700 posts and more than 100 pages), so it is not possible to filter the posts manually.
Will your tool make it possible to select posts with a specific category and specify tags that I do not want in my query?
I have this query, and it should work, but no matter what I do, I get the same number of posts (458) whether I add "and name not like 'ect'" or not. My goal is to find posts in category "sundhed & sygdom" that do not have the tag "ect". Can your tool help me?
SELECT ID, post_date, post_title, post_name FROM HBS_posts INNER JOIN HBS_term_relationships ON HBS_term_relationships.object_id = HBS_posts.ID INNER JOIN HBS_term_taxonomy ON HBS_term_taxonomy.term_taxonomy_id = HBS_term_relationships.term_taxonomy_id INNER JOIN HBS_terms ON HBS_terms.term_id = HBS_term_taxonomy.term_id Where name like 'sundhed & sygdom' and name not like 'ect' ORDER BY `HBS_posts`.`ID` DESC
Kind regards,
Hanne B. Stegemüller
Hi Hanne
If I am not mistaken, this is a duplicate ticket, so in case you missed my previous reply from a few days ago let me post it below:
This can be achieved using MySQL query-based tables. If you're not that good with MySQL, you can try using our Query Constructor, but please note that this constructor is just a helper - it's not an ultimate query generator.
It constructs a suggestion of a query, that you often need to modify to get the data you need. Included support for the plugin doesn't cover writing custom queries, so we wouldn't be able to help you with that.
The query you pasted below needs to be created as a view in order to function properly inside wpDataTables.
This is a complicated query so please have a look at the video and construct the view first then pull the data to wpDataTables and let me know if you still have any issues.
Looking forward to hearing from you.