Creating alarms on SQL data

Ignition
1

We are looking to start using Ignition to have users fill out a checklist, where they inspect the machine against a list of items, and check boxes in a power table for each item that passes, clicking a button to submit.

If any items fail, we want to raise an alarm, with some info about which machine and item failed.

Right now, we just write the data from the power table into SQL. Should we use query tags on our machine UDTs, like the pseudocode SELECT COUNT(failed_items) FROM checklists WHERE machine = {machine_name} AND isMostRecentChecklist, and then set up an alarm on that?

On a related topic, is there a way to handle the refresh rate of these query tags? If we have 30 machines, each one polling at 2000ms for a couple different query tags, that's not nothing. Do we place all of these tags into a tag group, and make it slower?

2

Does the alarm need to be raised immediately? Or can it wait for then entire checklist to be completed? Why not trigger immediately off the fail checkbox being selected?

If it can wait until the checklist is completed, just have your submit button pull all the records from the current checklist and check for any fails and alert accordingly. I feel like emails might be a more direct method of alerting.

I wouldn't rely on a tag alarm for this.

1 Like