Reporting alarm journal and tag history query

Ignition
1

I have two report data sources, an alarm journal and a tag history query.
In my report I have a table that has the eventTime, itemName, eventState which are keys from the alarm data source. In the fourth column of this table, I would like to retrieve a tag from the historical database for the length during production, to note at what length the alarm occurred.

Should I write a script or use a nested query under the alarm_journal or something else entirely to be able to retrieve the length at each specific eventTime.

Cheers

2

This is a task generally accomplished with an alarm's "Associated Data". Basically, include a custom property on the alarm definition and bind it to the length tag. That will cause the length, as a snapshot at the time of alarm, to be placed into the alarm history details table and associated with the alarm event. No need to do a history query.

1 Like
3

Thank you!