Need some help/direction, working on my first Ignition project and am trying to replicate the same or similar methods that we use on other SCADA platforms to maintain the same philosophy, yet take advantage of features when we can.
For alarm messages, we typically keep all alarm messages in an SQL database for a number of reasons. So, anytime an alarm occurs the SQL database is queried and the proper alarm message is returned. This is typically accomplished using a data change script of some sort. The alarm code is generated, SQL is queried and the message is returned to a dedicated alarm tag.
I’m sure I can replicate this with Ignition, although I wouldn’t mind some pointers on the scripting required to query a SQL database an return the string text to a memory tag.
However, I really think the alarm trend would be very handy for some alarms. For that to work I feel like I would need to configure the alarm conditions directly on the tags as the Alarm Trend will need a tag reference to access the historical data. Which means I would somehow have to dynamically change the message text on the tag when the alarm occurs. Or, I would have to dynamically change a general alarm tag, tag data reference so that the trend can pull up the proper alarm history.
Not sure I’m expecting an answer, just need to “talk it out” since it’s a new platform.