To see the table, please use the password tooclean
I have created a table and everything looks great. BUT, when a new order gets submitted, I need to have the order details added to the report. I built the table using the constructor. Then I added a new test order, but the table data did not update to include the new order details. How can I change it so that the report will change everytime new orders are submitted?
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 point me to the table ID so I can take a look.
Actually, after looking further, none of the columns are filtering. No matter what I type in any of the filters below each column or in the search box, I always get "No results".
I logged in successfully. I have some questions before I can investigate it.
I saw from your post below that you used wpdatatables constructor and if you take a look at our documentation you can see that wpDataTables Constructor is just a helper:
"Please note that WPDB query constructor 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 our suggestion is when you have queries like this, can you please make a VIEW in phpmyadmin or any other database management system and see if filtering is working.
If the VIEW is returning the desired data and filtering is working you can use that query as Add from data source option to create tables.
To see the table, please use the password tooclean
I have created a table and everything looks great. BUT, when a new order gets submitted, I need to have the order details added to the report. I built the table using the constructor. Then I added a new test order, but the table data did not update to include the new order details. How can I change it so that the report will change everytime new orders are submitted?
Hi lujeffcoat,
Thank you for your purchase.
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 point me to the table ID so I can take a look.
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
Actually, after looking further, none of the columns are filtering. No matter what I type in any of the filters below each column or in the search box, I always get "No results".
Hi lujeffcoat,
I logged in successfully.
I have some questions before I can investigate it.
I saw from your post below that you used wpdatatables constructor and if you take a look at our documentation you can see that wpDataTables Constructor is just a helper:
"Please note that WPDB query constructor 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 our suggestion is when you have queries like this, can you please make a VIEW in phpmyadmin or any other database management system and see if filtering is working.
Let me know the result.If the VIEW is returning the desired data and filtering is working you can use that query as Add from data source option to create tables.
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