Can anyone suggest which is the best way to keep the table refreshed in all open sessions/clients where I want to keep the polling off for Query Binding.
I know system.db.refresh and refreshBinding works on current session/client.
- I keep a ‘datetime memory tag’ updated on every script end where the SQL data is modified.
- Placed a label component, bind to the memory tag in in view/window as ‘last update value’
- Written a script on value change to refresh the table data.
This keeps on table data update on every open session/client.
Is this the correct way or any other suggestion to be more effective?