Update Table Every minute

  • Resolved talacatori

    (@talacatori)


    2 years, 2 months ago

    Hello I would like to know if there is possibility to update table every minute…,
    So I have table on wp lets say named “orders” and I want to be able to see the orders in my application on SQL SERVER, or at least a shortcode that I can execute when someone clicks button on wp

    • This topic was modified 2 years, 2 months ago by talacatori.
    • This topic was modified 2 years, 2 months ago by talacatori.
Viewing 1 replies (of 1 total)
  • Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    Hi @talacatori,

    The following code will auto update your table every 60 seconds. You can change the interval to whatever you like.

    {
	"initComplete": "function(settings, json) { setInterval(function() { jQuery('#'+settings.sTableId).DataTable().ajax.reload(null,false) }, 60000) }"
}

    Please enter this code in the advanced options field of your publication. Using advanced options is explained here:
    https://wpdataaccess.com/docs/data-publisher/advanced-settings/

    Let me know if you need further assistance.

    Hope this helps,
    Peter

Viewing 1 replies (of 1 total)
  • The topic ‘Update Table Every minute’ is closed to new replies.