Alarm Status Table and Alarm Journal Components

Ignition
4

Below is the solution I ended up using for this:

from com.inductiveautomation.ignition.common.alarming.config import CommonAlarmProperties

range = event.source.parent.getComponent(‘Date Range’)
table = system.alarm.queryJournal(journalName=‘Journal’, startDate = range.startDate, endDate = range.endDate, includeSystem=True, includeData=True)

ackUserData = []
for row in table:
ackUserData.append(str(row.get(CommonAlarmProperties.AckUserName)))
ackNotes = []
for row in table:
ackNotes.append(str(row.get(CommonAlarmProperties.AckNotes)))
nameData = []
for row in table:
nameData.append(str(row.get(CommonAlarmProperties.Name)))

tableData = table.getDataset()
tableData = system.dataset.addColumn(tableData,ackUserData,‘Ack User’,type(str()))
tableData = system.dataset.addColumn(tableData,ackNotes,‘Ack Notes’,type(str()))
tableData = system.dataset.addColumn(tableData,nameData,‘Label’,type(str()))

filePath = system.dataset.exportExcel(“data.xls”, 1, tableData)
if filePath != None:
system.net.openURL(“file://”+filePath)

1 Like