I am trying to figure out how my predecessor set something up and I am hoping someone here can point me in the right direction…
We are collecting data about a particular batch into many separate data tables in mySQL using transaction groups in Ignition triggered by an event in the PLC. All this makes sense and it is easy to see what is going on. However all this data is then being pushed into a single master table that we use for displaying all the batch data. I know there is a script running somewhere to do this but I can not find it in Ignition (or I am just not looking in the right place). Suggestions on how this might be working or where to look?
Look in the MySQL database for any triggers defined on the tables specified in your transaction groups. Database triggers are arbitrary stored procedures that run (in the database) when data is added or modified in a table.
Thanks for the feedback. I will have look at manually adding data to the other tables
I checked the gateway scripts, there are several but none that have anything to do with this.
I also looked at the SQL table triggers, I don’t see any when I click on the trigger heading for each table.
Drinking beer has not helped me figure this out yet… I will try and drink more and see if my luck improves.