I have a SQL database on AWS that is updated every second. Each table represents a different fuel tank. Every second is far too granular and so I'm looking for a solution that would enable my wpdatatable to check every 8 hours (or 12 or even 24 hours) and update the percentage left in the tank. Also for the chart then to reflect the current percentage left in the tank. Is this possible?
Every server-side table (manual and SQL Query based tables) have the auto-refresh option. If you enter the amount of seconds after which the table will refresh, it will do so without the need to refresh the entire page.
When you create a chart from that table, you need to enable "Follow table filtering" during Chart creation, and place both the table and the chart on the same page. It will also refresh at the same moment. So, the only thing you need to do is apply the time in seconds after which the table will automatically refresh, and that's it.
I have a SQL database on AWS that is updated every second. Each table represents a different fuel tank. Every second is far too granular and so I'm looking for a solution that would enable my wpdatatable to check every 8 hours (or 12 or even 24 hours) and update the percentage left in the tank. Also for the chart then to reflect the current percentage left in the tank. Is this possible?
Objective:
25 tanks - regularly measured (so 25 wpdatatables & 25 charts)
query to AWS table every 8 hours and get latest record for each tank percentage full (e.g. 49.1, 78.2, 12.4, etc.)
update each of the 25 wpdatables for individual tanks with latest record.
update each of the 25 charts with latest information from respective table.
Hello Joshua.
Thank you for your purchase.
Every server-side table (manual and SQL Query based tables) have the auto-refresh option. If you enter the amount of seconds after which the table will refresh, it will do so without the need to refresh the entire page.
When you create a chart from that table, you need to enable "Follow table filtering" during Chart creation, and place both the table and the chart on the same page. It will also refresh at the same moment. So, the only thing you need to do is apply the time in seconds after which the table will automatically refresh, and that's it.
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
Brilliant! Thank you for that reply. I'll look into this and attempt to make it work. Sounds simple enough.
You're welcome Joshua.
Glad I could help.
If you have any further questions or issues, please feel free to open a new ticket, and we'll gladly help.
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