# Retrieve acknowledgement notes

**URL:** <https://forum.inductiveautomation.com/t/retrieve-acknowledgement-notes/20353>\
**Category:** Ignition\
**Created:** [October 24, 2018, 6:27pm UTC](https://forum.inductiveautomation.com/t/retrieve-acknowledgement-notes/20353 "2018-10-24T18:27:29Z")\
**Posts on this page:** 10\
**Page:** 1

<div class="post-metadata">

**Author:** ![adolfo.rafael.martin](https://avatars.discourse-cdn.com/v4/letter/a/ac8455/32.png) [@adolfo.rafael.martin](https://forum.inductiveautomation.com/u/adolfo.rafael.martin)\
**Post date:** [October 24, 2018, 6:27pm UTC](https://forum.inductiveautomation.com/t/retrieve-acknowledgement-notes/20353/1 "2018-10-24T18:27:29Z")

</div>

I’ll use

system.alarm.acknowledge

to acknowledge alarms with notes.  
but I’ll use

system.alarm.queryStatus

to retrieve alarm status  
but, I don’t find any acknowledgement notes.

How should I correctly retrieve the acknowledgement notes?

---

<div class="post-metadata">

**Author:** ![ethomason](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/ethomason/32/43338_2.png) [@ethomason](https://forum.inductiveautomation.com/u/ethomason)\
**Post date:** [October 24, 2018, 8:14pm UTC](https://forum.inductiveautomation.com/t/retrieve-acknowledgement-notes/20353/2 "2018-10-24T20:14:44Z")

</div>

[System.alarm.queryStatus](https://docs.inductiveautomation.com/display/DOC79/system.alarm.queryStatus) will return a list of AlarmEvent objects

You can call getNotes on those AlarmEvent objects:

[https://docs.inductiveautomation.com/display/DOC79/Alarm+Event+Properties+Reference#AlarmEventPropertiesReference-TheAlarmEventObject](https://docs.inductiveautomation.com/display/DOC79/Alarm+Event+Properties+Reference#AlarmEventPropertiesReference-TheAlarmEventObject)

---

<div class="post-metadata">

**Author:** ![adolfo.rafael.martin](https://avatars.discourse-cdn.com/v4/letter/a/ac8455/32.png) [@adolfo.rafael.martin](https://forum.inductiveautomation.com/u/adolfo.rafael.martin)\
**Post date:** [October 25, 2018, 12:12pm UTC](https://forum.inductiveautomation.com/t/retrieve-acknowledgement-notes/20353/3 "2018-10-25T12:12:57Z")

</div>

thank you, ethomason!!

---

<div class="post-metadata">

**Author:** ![adolfo.rafael.martin](https://avatars.discourse-cdn.com/v4/letter/a/ac8455/32.png) [@adolfo.rafael.martin](https://forum.inductiveautomation.com/u/adolfo.rafael.martin)\
**Post date:** [October 29, 2018, 7:11pm UTC](https://forum.inductiveautomation.com/t/retrieve-acknowledgement-notes/20353/6 "2018-10-29T19:11:07Z")

</div>

Hi;

I used getNotes() in the following code but it returns blank. But, when I check the Ignition Alarm Status Table created in a GUI, it shows the notes.

alarms = system.alarm.queryStatus(State=["ActiveUnacked","ActiveAcked","ClearAcked","ClearUnacked"], includeShelved="false")

logger.info(str(type(alarms[0])))  
# \<type 'com.inductiveautomation.ignition.common.alarming.BasicAlarmEvent'\>

logger.info(str(type(alarms[0].getNotes())))  
# \<type 'unicode'\>

logger.info(str(len(str(alarms[0].getNotes()))))  
# len: 0

What could be wrong?

---

<div class="post-metadata">

**Author:** ![ethomason](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/ethomason/32/43338_2.png) [@ethomason](https://forum.inductiveautomation.com/u/ethomason)\
**Post date:** [October 29, 2018, 8:10pm UTC](https://forum.inductiveautomation.com/t/retrieve-acknowledgement-notes/20353/7 "2018-10-29T20:10:04Z")

</div>

You are only looking at one alarm event. What happens when you loop through the entire dataset?

---

<div class="post-metadata">

**Author:** ![adolfo.rafael.martin](https://avatars.discourse-cdn.com/v4/letter/a/ac8455/32.png) [@adolfo.rafael.martin](https://forum.inductiveautomation.com/u/adolfo.rafael.martin)\
**Post date:** [October 29, 2018, 8:29pm UTC](https://forum.inductiveautomation.com/t/retrieve-acknowledgement-notes/20353/8 "2018-10-29T20:29:45Z")

</div>

There was only one alarm in the set. And, it comes from an Inductive Automation server that I have set up for development. It only has one tag. And, then I put it into alarm. I actually had a loop that would iterate through the alarms object in general. But, I took it out to make the troubleshooting easier. What do you think I should do?

---

<div class="post-metadata">

**Author:** ![adolfo.rafael.martin](https://avatars.discourse-cdn.com/v4/letter/a/ac8455/32.png) [@adolfo.rafael.martin](https://forum.inductiveautomation.com/u/adolfo.rafael.martin)\
**Post date:** [October 29, 2018, 8:47pm UTC](https://forum.inductiveautomation.com/t/retrieve-acknowledgement-notes/20353/9 "2018-10-29T20:47:31Z")

</div>

I should add that I compared the UUID of the alarm from queryStatus with the UUID of the alarm that appears in the Alarm Status Table created using designer. The UUID was the same for both of them.

---

<div class="post-metadata">

**Author:** ![adolfo.rafael.martin](https://avatars.discourse-cdn.com/v4/letter/a/ac8455/32.png) [@adolfo.rafael.martin](https://forum.inductiveautomation.com/u/adolfo.rafael.martin)\
**Post date:** [October 30, 2018, 4:22pm UTC](https://forum.inductiveautomation.com/t/retrieve-acknowledgement-notes/20353/11 "2018-10-30T16:22:39Z")

</div>

Can you remote into the machine to help me out?

---

<div class="post-metadata">

**Author:** ![ethomason](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/ethomason/32/43338_2.png) [@ethomason](https://forum.inductiveautomation.com/u/ethomason)\
**Post date:** [October 30, 2018, 4:50pm UTC](https://forum.inductiveautomation.com/t/retrieve-acknowledgement-notes/20353/12 "2018-10-30T16:50:50Z")

</div>

Hi Adolfo, if you need immediate assistance I recommend getting in contact with support.

---

<div class="post-metadata">

**Author:** ![Matthieu\_Dorge](https://avatars.discourse-cdn.com/v4/letter/m/3d9bf3/32.png) [@Matthieu\_Dorge](https://forum.inductiveautomation.com/u/Matthieu_Dorge)\
**Post date:** [July 28, 2022, 3:32pm UTC](https://forum.inductiveautomation.com/t/retrieve-acknowledgement-notes/20353/13 "2022-07-28T15:32:47Z")

</div>

Solution Named Query :

SELECT a.id, a.displaypath, a.eventtime, b.notes, b.user  
FROM alarm\_events a  
LEFT JOIN (SELECT TAB\_1.id, TAB\_1.notes, TAB\_2.user FROM  
(SELECT id,  
strvalue as ‘notes’  
FROM alarm\_event\_data  
WHERE propname = ‘ackNotes’) AS TAB\_1,  
(SELECT id  
,strvalue as ‘user’  
FROM alarm\_event\_data  
WHERE propname = ‘ackUser’) AS TAB\_2  
WHERE TAB\_1.id = TAB\_2.id) AS b  
ON a.id = b.id

WHERE b.notes IS NOT NULL  
ORDER BY a.eventtime DESC
