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.
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.
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?
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.
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.
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.
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