I’m trying to create a table based on WordPress database, and I would like to display only certain type of post category on this table, but when I tried to had a post.taxonomy.category condition when crating the table I have a error message (see the attached file).
I’ve tried with = like, %like% and also category ID but unfortunately, it’s not working.
Unfortunately if you take a look at our documentation you will see 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.
So when you have queries like this our suggestion is to make a VIEW in phpmyadmin or any other database management system and see if the query is returning the right result. If the result is good you can use that query as an input when creating tables with add from data source option.
Hi,
I’m trying to create a table based on WordPress database, and I would like to display only certain type of post category on this table, but when I tried to had a post.taxonomy.category condition when crating the table I have a error message (see the attached file).
I’ve tried with = like, %like% and also category ID but unfortunately, it’s not working.
Could you help me with this?
Regards
HI Crisotech,
Thank you for your purchase.
Unfortunately if you take a look at our documentation you will see 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.
So when you have queries like this our suggestion is to make a VIEW in phpmyadmin or any other database management system and see if the query is returning the right result. If the result is good you can use that query as an input when creating tables with add from data source option.
Hope this can help.
Best regards.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
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