As previously announced via banners and our newsletters, support is no longer available through this platform.
For easier navigation, you can still click on "Submit a Ticket" here, choose the appropriate category, and you'll be redirected to the correct support channel for your plugin.
You can still access your previous tickets and browse public tickets, but please note that responding to tickets is no longer possible.
Paid customers: Please log in to your store account for support.
Pre-purchase questions: Use the support widget in the bottom-right corner of our websites:
https://wpamelia.com
https://wpdatatables.com
https://wpreportbuilder.com
I am trying to create a table by querying the Wordpress Posts. I have no trouble creating a table of Posts, including the Tags/Category Taxonomy. The problem starts when I try to FILTER by taxonomy. If I add a condition, like:
post.taxonomy.category = Stocks
it returns an error like this:
No results found. Please check if this query is correct! Table Constructor needs a query that returns data to build a wpDataTable.
I've tried searching by category ID#, Title, and Slug, and get the same result each time. If I remove the filter and click Next, wpDataTables displays a preview of the table, including the taxonomy info, with no trouble. The moment I add any taxonomy filter, I get the error. Other filters, such as "by author", work just fine.Error: Unknown column 'post_taxonomy_category' in 'on clause'
Hi David
Thank you for reaching out to us.
I suppose you used our Query Constructor to create that table.
Please note that this tool is not an ultimate query generator. It simply constructs a suggestion of a query. We are constantly working to improve it, but SQL is such a complicated and flexible language that full automation for constructing queries is next to impossible. Consequently, the more complicated the query, the higher is the probability that it will not return exactly what you need. So, you will often need to play around with the resulting query.
Issues with editing, sorting and/or filtering can happen with tables that contain multiple JOINs, CONCATs, and other statements in the query. If this is the case on your server-side table, you can either disable server-side processing (if you don't need the table to be editable, and you don't have over 2.000 rows of data), or prepare a MySQL view (a stored query), which will return the data that you need, call it e.g. “view1” and then build a wpDataTabled based on a simple query like “SELECT * FROM view1″.
Please note some this when working with the server-side processing feature:
Could I kindly ask you to send us the query so we can take a closer look?