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
Hi All,
I am currently converting my existing php chartjs pages over to wordpress using the wpdatatables.
Could I ask how to filter the query by day. I currently use = DATE(NOW) but I am not sure this works in this environment.
here is the query I am trying
SELECT temperatures.`dateMeasured`,
temperatures.`temperature`,
temperatures.`hourMeasured`
FROM temperatures
WHERE temperatures.`dateMeasured` = DATE(NOW)
but I must have the syntax wrong
any help would be appreciated
Thanks
Wayne
Hi All,
Sorry I realised what I had done. I went via the "Generate a query to MySQL database" option but needed to go via the "Create a table linked to an existing data source" this works perfectly with my existing sql queries.
Thanks
Wayne
Great news, Wayne.
Thank you for your purchase.
Thank you for letting us know.
If you have any more issues or questions feel free to open a new ticket, we will gladly help.
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