# Referencing sql query data in Tag historian in report

**URL:** <https://forum.inductiveautomation.com/t/referencing-sql-query-data-in-tag-historian-in-report/57987>\
**Category:** Ignition\
**Tags:** ignition81\
**Created:** [April 4, 2022, 7:22am UTC](https://forum.inductiveautomation.com/t/referencing-sql-query-data-in-tag-historian-in-report/57987 "2022-04-04T07:22:04Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Kartik\_I](https://avatars.discourse-cdn.com/v4/letter/k/8c91f0/32.png) [@Kartik\_I](https://forum.inductiveautomation.com/u/Kartik_I)\
**Post date:** [April 4, 2022, 7:22am UTC](https://forum.inductiveautomation.com/t/referencing-sql-query-data-in-tag-historian-in-report/57987/1 "2022-04-04T07:22:04Z")

</div>

How to reference sql query attribute in Tag historian. For example I have station number from sql query how to reference it to tag historian station number. refer images for better understanding

 ![Child Nested query](https://us1.discourse-cdn.com/inductiveautomation/original/3X/b/3/b39bbc70e29b1acaa373a26ed1fa9cb88fc81ae9.png)  
 ![Parent Nested query](https://us1.discourse-cdn.com/inductiveautomation/original/3X/7/0/704c46ebfacde7ec960d43f417c48361bcca1ea8.png)

---

<div class="post-metadata">

**Author:** ![Kartik\_I](https://avatars.discourse-cdn.com/v4/letter/k/8c91f0/32.png) [@Kartik\_I](https://forum.inductiveautomation.com/u/Kartik_I)\
**Post date:** [April 4, 2022, 12:17pm UTC](https://forum.inductiveautomation.com/t/referencing-sql-query-data-in-tag-historian-in-report/57987/4 "2022-04-04T12:17:22Z")

</div>

any updates for this how to do it?

---

<div class="post-metadata">

**Author:** ![Paolo.Mariani](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paolo.mariani/32/3285_2.png) [@Paolo.Mariani](https://forum.inductiveautomation.com/u/Paolo.Mariani)\
**Post date:** [April 4, 2022, 3:21pm UTC](https://forum.inductiveautomation.com/t/referencing-sql-query-data-in-tag-historian-in-report/57987/5 "2022-04-04T15:21:58Z")

</div>

Closed on April 4, 2022, 3:21pm UTC



---

<div class="post-metadata">

**Author:** ![Paolo.Mariani](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paolo.mariani/32/3285_2.png) [@Paolo.Mariani](https://forum.inductiveautomation.com/u/Paolo.Mariani)\
**Post date:** [April 4, 2022, 3:22pm UTC](https://forum.inductiveautomation.com/t/referencing-sql-query-data-in-tag-historian-in-report/57987/6 "2022-04-04T15:22:27Z")

</div>

If you have questions on the test, please email [training@inductiveautomation.com](mailto:training@inductiveautomation.com)