# Pipeline – Passing Associated Data to Calculated Roster

**URL:** <https://forum.inductiveautomation.com/t/pipeline-passing-associated-data-to-calculated-roster/57792>\
**Category:** Ignition\
**Tags:** ignition81\
**Created:** [March 30, 2022, 7:54am UTC](https://forum.inductiveautomation.com/t/pipeline-passing-associated-data-to-calculated-roster/57792 "2022-03-30T07:54:04Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![FreddyR](https://avatars.discourse-cdn.com/v4/letter/f/f0a364/32.png) [@FreddyR](https://forum.inductiveautomation.com/u/FreddyR)\
**Post date:** [March 30, 2022, 7:54am UTC](https://forum.inductiveautomation.com/t/pipeline-passing-associated-data-to-calculated-roster/57792/1 "2022-03-30T07:54:04Z")

</div>

Hi everyone,  
I am using **system.db.runQuery** in my calculated roster to build a roster to Alarm notification.  
I have already added an associated data in my alarm.  
Is there any way to pass that associated data into my query as I want to filter some of the users in my calculated roster.

FYI, I watched this video from, i just dont know if it is possible to pass the associate data into my query.  
[Pipeline – Filter on Alarm Associated Data - Alarm Notification Pipelines (inductiveuniversity.com)](https://inductiveuniversity.com/videos/pipeline-filter-on-alarm-associated-data/8.0)

---

<div class="post-metadata">

**Author:** ![kvane](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kvane/32/22228_2.png) [@kvane](https://forum.inductiveautomation.com/u/kvane)\
**Post date:** [March 30, 2022, 7:02pm UTC](https://forum.inductiveautomation.com/t/pipeline-passing-associated-data-to-calculated-roster/57792/2 "2022-03-30T19:02:02Z")

</div>

There is an example of accessing associated data in a calculated roster on this User Manual page: [Notification Block - Ignition User Manual 8.1 - Ignition Documentation](https://docs.inductiveautomation.com/display/DOC81/Notification+Block)

From the manual:

> You can access any of the alarm properties through the event object in a calculated roster. Properties are stored as a dictionary and can be accessed in the same way.

```auto
# properties can be accessed directly using the dictionary format
# event["propertyname"]
 
# get the alarm name
alarmName = event["name"]
 
# get an associated data property named "Machine Area"
associatedArea = event["Machine Area"]

```

---

<div class="post-metadata">

**Author:** ![FreddyR](https://avatars.discourse-cdn.com/v4/letter/f/f0a364/32.png) [@FreddyR](https://forum.inductiveautomation.com/u/FreddyR)\
**Post date:** [April 1, 2022, 7:07am UTC](https://forum.inductiveautomation.com/t/pipeline-passing-associated-data-to-calculated-roster/57792/3 "2022-04-01T07:07:21Z")

</div>

Thanks @kvane I missed it from user manual.