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

Okay
  Public Ticket #2225442
wwpdatatables and mysql
Closed

Comments

  • john started the conversation

    I have a chart in a wordpress page populated by a SQL table using your plugin. I am not publishing the table in the wordpress page, just the chart.

    My question (1) is whether the opening of the wordpress page will automatically refresh the SQL query and therefore table and therefore the chart. 

    When I load the table in a page, it seems to refresh the data automatically when that page is opened, but not if there is just the chart.

    My follow up question (2): is there  way of either having the chart data refreshed automatically on opening the wordpress page or on a timer, such as every 24 hours?

  •  2,576
    Aleksandar replied

    Hello john.

    The charts depend on the table, so when the page is refreshed it will pull the data from the table. 

    SQL Query based tables are refreshed instantaneously, so when you refresh the page, the plugin will display whatever change was made in the database.

    If you wish your chart to auto-refresh, you can add the auto-refresh interval in the table, enable "Follow table filtering" when creating the chart, and then place them both on the same page. If you don't want to show the table, you can hide it with some custom CSS.

    Kind Regards, 

    Aleksandar Vuković
    [email protected]

    Rate my support

    wpDataTables: FAQ | Facebook | Twitter | InstagramFront-end and back-end demo | Docs

    Amelia: FAQ | Facebook | Twitter | InstagramAmelia 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