Greeting, Ignition community,
I am working on a project which requires me to create a real time dashboard that is driven from an external MES system (one that was custom built a while ago). In particular this MES system has a "status" table that contains the status of all mes terminals (so all data is in that table). I would like to create this dashboard in ignition perspective, and my plan was to pull the data I need from the status table and write it to a series of tags.
Ideally, I would like to update my tags only when the data in the status table changes. I was thinking of using "transaction groups" to do this, but I am not sure if this is the correct approach or if it is, how to go about it.
If anyone has any suggestions I would greatly appreciate it. So far I am tinkering with transaction groups, but I don't really understand how to "bind" a tag to a row/column value in the database so that when I change the row/column value it updates the tag.