Drop Selected Alarms (Database Journal)

Ignition
, ,
1

I would like to add a button to my window (only visible in the designer) that I could use to quickly drop rows from the underlying alarm database. (alarms that were raised as a result of testing - that I don't want to confuse operators with)

The alarm journal is configured as an SQL database source. Just not sure how I go about it with all the different related tables in the database.

2

Selecting the rows and inspecting the Selected Alarms prop, I see the EventId column, but I get no results when I try and use the query browser.

SELECT * from alarm_events where eventid = "c4584a93-b62d-4aca-8620-bfd5acc4a61f"
3

Use single quotes for values in SQL. Double quotes are for identifiers.

4

Still nothing

SELECT * from alarm_events where eventid = 'c4584a93-b62d-4aca-8620-bfd5acc4a61f'
5

You may need to cast that value to the DB's UUID type.

6

Looks like it uses a different event ID.

event ID in the alarm journal component:

c4584a93-b62d-4aca-8620-bfd5acc4a61f

selecting using the source instead, I see event ID:

9acbaa2a-adec-41e6-9153-d067bca70d63

(that's the only alarm event with the same source)

7

Whoever set up the table set it up as an alarm status table looking at only cleared events, instead of a journal. These were orphaned alarms and that's why they didn't show up in the database.