I want to provide the option to export the alarm event data for reporting purposes. My users want an excel document with the alarm source, event type, event time, ack user, and ack notes. I have not been able to get system.alarm.queryJournal to return ack-user or ack-notes. Any ideas?
start = self.getSibling(DateTimeInput_StartTime).props.value
end = self.getSibling(DateTimeInput_EndTime).props.value
journal = system.alarm.queryJournal(journalName=Substation, startDate=start, endDate=end, includeData=True).getDataset()
data = system.dataset.toExcel(1, [journal])
fileName = Substation_Journal.xlsx
system.perspective.download(fileName,data)