# queryAlartStatus in loop

**URL:** <https://forum.inductiveautomation.com/t/queryalartstatus-in-loop/5751>\
**Category:** Ignition\
**Created:** [January 28, 2013, 10:13pm UTC](https://forum.inductiveautomation.com/t/queryalartstatus-in-loop/5751 "2013-01-28T22:13:23Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![scott\_rister](https://avatars.discourse-cdn.com/v4/letter/s/5daacb/32.png) [@scott\_rister](https://forum.inductiveautomation.com/u/scott_rister)\
**Post date:** [January 28, 2013, 10:13pm UTC](https://forum.inductiveautomation.com/t/queryalartstatus-in-loop/5751/1 "2013-01-28T22:13:23Z")

</div>

I am trying to come up with a count of active alarms in various different paths. i have the paths defined in a dataset called Systems. I read the path and then run the queryAlartStatus on the path using %s.

Here is the code:  
data = event.source.parent.Systems  
NumAlarms = 0  
for row in range(data.rowCount):  
almPath = data.getValueAt(row,0)  
result=system.alert.queryAlertStatus(path=’%s’, activeAndAcked=1, activeAndUnacked=1).rowCount %(almPath)  
NumAlarms=NumAlarms + result  
print NumAlarms

here is the error returned:  
TypeError: unsupported operand type(s) for %: ‘int’ and ‘unicode’

if i print the almPath they are correct.  
if replace %s with %i it will run, just returns bogus data.

Thanks for the help.  
Scott

---

<div class="post-metadata">

**Author:** ![Travis.Cox](https://avatars.discourse-cdn.com/v4/letter/t/b9bd4f/32.png) [@Travis.Cox](https://forum.inductiveautomation.com/u/Travis.Cox)\
**Post date:** [January 28, 2013, 10:50pm UTC](https://forum.inductiveautomation.com/t/queryalartstatus-in-loop/5751/2 "2013-01-28T22:50:19Z")

</div>

It should look like this:`data = event.source.parent.Systems
NumAlarms = 0
for row in range(data.rowCount):
    almPath = data.getValueAt(row,0)
    result=system.alert.queryAlertStatus(path='%s' % almPath, activeAndAcked=1, activeAndUnacked=1).rowCount
    NumAlarms=NumAlarms + result
print NumAlarms`

---

<div class="post-metadata">

**Author:** ![scott\_rister](https://avatars.discourse-cdn.com/v4/letter/s/5daacb/32.png) [@scott\_rister](https://forum.inductiveautomation.com/u/scott_rister)\
**Post date:** [January 28, 2013, 10:56pm UTC](https://forum.inductiveautomation.com/t/queryalartstatus-in-loop/5751/3 "2013-01-28T22:56:57Z")

</div>

Thanks!