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