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!
So I created a query based on 2 tables so 2 columns are equal (=) and the preview shows the correct results.
However when I go to the next step of create the table the table shows no data (no data to display).
However when I click the apply button I get a flash of the table showing the previous preview results and then nothing, back to the message (no data to display).
I checked the Mysql query language and it appears to be generated correctly by wpdatatables (well it would not have worked in preview if it was incorrect).
I have gone through everything and I cant see where the problem is.
Hello Ben.
If I'm not mistaken, you're using our query constructor to generate the table, correct?
If that is true, 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.
Can you show me the query?
Best regards.
Kind Regards,
Aleksandar Vuković
[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
Aleksandar,
The query works well and I can see the results. When creating the table, the data is not displayed. However I found that if I turned off the filter option in the edit table properties the query data can be seen. Dont know why but turn the filter on - no data is diplayed. Turn the filter off - data is displayed.
So all good Aleksander. It works.
Hi again Ben.
Glad to hear it works now!
When you say you turned off the filter option - you mean the conditions between two tables:
or actual filtering when the table gets generated:
Best regards?
Kind Regards,
Aleksandar Vuković
[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
Aleksandar,
Apologies. It is not the filter but the Sorting.
Turn it off - all good.
Turn it on - no data
Hi again Ben.
Well when you're creating a table using the query constructor - it has some issues like I mentioned before. It tries to guess what you wanted to query, and even though it came up with good results, you may need to work on the query, and modify it in some way to get sorting, search and/or filtering to work properly.
Best regards.
Kind Regards,
Aleksandar Vuković
[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