# Timeseries Chart using nested query **URL:** \ **Category:** Ignition\ **Tags:** ignition81\ **Created:** [April 19, 2024, 7:01am UTC](https://forum.inductiveautomation.com/t/timeseries-chart-using-nested-query/89096 "2024-04-19T07:01:37Z")\ **Posts on this page:** 12\ **Page:** 1
**Author:** ![Alagumani\_Kaliyaperu](https://avatars.discourse-cdn.com/v4/letter/a/8baadc/32.png) [@Alagumani\_Kaliyaperu](https://forum.inductiveautomation.com/u/Alagumani_Kaliyaperu)\ **Post date:** [April 19, 2024, 7:01am UTC](https://forum.inductiveautomation.com/t/timeseries-chart-using-nested-query/89096/1 "2024-04-19T07:01:37Z")
Hi, I'm creating dynamic report using the nested query, In my parent query I collect the station information from Database then in child, I'm using the Tag Historian Query to pull my data for Timeseries chart. But I'm not sure how to pass the parent query information to child Tag Historian Query to make it dynamic. can anybody suggest me some concept to make it work. ---
**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\ **Post date:** [April 19, 2024, 10:35am UTC](https://forum.inductiveautomation.com/t/timeseries-chart-using-nested-query/89096/2 "2024-04-19T10:35:54Z")
> [@Alagumani\_Kaliyaperu](#): > > dynamic report Reports aren't dynamic. They collect data when told to do so, and generate a static report from that data. User interfaces like Perspective or Vision is where you create "live" displays. ---
**Author:** ![Alagumani\_Kaliyaperu](https://avatars.discourse-cdn.com/v4/letter/a/8baadc/32.png) [@Alagumani\_Kaliyaperu](https://forum.inductiveautomation.com/u/Alagumani_Kaliyaperu)\ **Post date:** [April 21, 2024, 8:11am UTC](https://forum.inductiveautomation.com/t/timeseries-chart-using-nested-query/89096/3 "2024-04-21T08:11:19Z")
@pturmel Thanks for reply. Sorry, I will rephrase my question because I have updated my report, I created nested query with one child. In parent I'm getting the station number as Num, then I pass this parameter to the child query(Tag History Query). In the design on table header I add the station details & Timeseries chart but my chart not showing any values. ![Report1](https://us1.discourse-cdn.com/inductiveautomation/original/3X/d/d/dd74644c4b82e1ff9c52eb0a974a468189bfb4b7.png) ![Report2](https://us1.discourse-cdn.com/inductiveautomation/original/3X/b/a/bacfb8f8daf86a2c0664c60b92bc628b59c40243.png) ![Report3](https://us1.discourse-cdn.com/inductiveautomation/original/3X/2/b/2b4f89abd2b50c336d1d4fbd7452c9b1a74325a2.png) ---
**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\ **Post date:** [April 21, 2024, 2:00pm UTC](https://forum.inductiveautomation.com/t/timeseries-chart-using-nested-query/89096/4 "2024-04-21T14:00:26Z")
Hmmm. Can you **see** the data for the chart in your XML sidebar in preview? ---
**Author:** ![Alagumani\_Kaliyaperu](https://avatars.discourse-cdn.com/v4/letter/a/8baadc/32.png) [@Alagumani\_Kaliyaperu](https://forum.inductiveautomation.com/u/Alagumani_Kaliyaperu)\ **Post date:** [April 21, 2024, 2:40pm UTC](https://forum.inductiveautomation.com/t/timeseries-chart-using-nested-query/89096/5 "2024-04-21T14:40:32Z")
I couldn't see it. Just showing null. ![Report4](https://us1.discourse-cdn.com/inductiveautomation/original/3X/b/4/b4e34e4f52aa94bf13c8ec8bb0b7ecafee93ec94.png) ---
**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\ **Post date:** [April 21, 2024, 2:53pm UTC](https://forum.inductiveautomation.com/t/timeseries-chart-using-nested-query/89096/6 "2024-04-21T14:53:32Z")
Hmmm. That's odd. I'm not sure what is going on. Can you show the subquery as a top-level query with a manually-supplied station number? (I suspect `{Num}` isn't stringifying like you expect.) ---
**Author:** ![Alagumani\_Kaliyaperu](https://avatars.discourse-cdn.com/v4/letter/a/8baadc/32.png) [@Alagumani\_Kaliyaperu](https://forum.inductiveautomation.com/u/Alagumani_Kaliyaperu)\ **Post date:** [April 21, 2024, 3:02pm UTC](https://forum.inductiveautomation.com/t/timeseries-chart-using-nested-query/89096/7 "2024-04-21T15:02:45Z")
Yeah I can do that. But my report table will adjust based on database details. Incase in future if I add stations in database then report don't know about it ---
**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\ **Post date:** [April 21, 2024, 4:42pm UTC](https://forum.inductiveautomation.com/t/timeseries-chart-using-nested-query/89096/8 "2024-04-21T16:42:29Z")
Right, but just for testing. Show the tag path for one station for the chart data. ---
**Author:** ![Alagumani\_Kaliyaperu](https://avatars.discourse-cdn.com/v4/letter/a/8baadc/32.png) [@Alagumani\_Kaliyaperu](https://forum.inductiveautomation.com/u/Alagumani_Kaliyaperu)\ **Post date:** [April 22, 2024, 1:53am UTC](https://forum.inductiveautomation.com/t/timeseries-chart-using-nested-query/89096/9 "2024-04-22T01:53:17Z")
Hi, I notices that now XML showing some data with same {Num} parameter, but my chart not showing the graph. ![Report5](https://us1.discourse-cdn.com/inductiveautomation/original/3X/e/4/e4115153a5f229e12ed687b540e84d2fe78021b2.png) ---
**Author:** ![Alagumani\_Kaliyaperu](https://avatars.discourse-cdn.com/v4/letter/a/8baadc/32.png) [@Alagumani\_Kaliyaperu](https://forum.inductiveautomation.com/u/Alagumani_Kaliyaperu)\ **Post date:** [April 22, 2024, 2:31am UTC](https://forum.inductiveautomation.com/t/timeseries-chart-using-nested-query/89096/10 "2024-04-22T02:31:01Z")
Hi, After I adjust the Data key, Domain key & Range key my chart working fine, Thanks for your support. ---
**Author:** ![steven\_saucedo1](https://avatars.discourse-cdn.com/v4/letter/s/c0e974/32.png) [@steven\_saucedo1](https://forum.inductiveautomation.com/u/steven_saucedo1)\ **Post date:** [August 27, 2024, 10:53pm UTC](https://forum.inductiveautomation.com/t/timeseries-chart-using-nested-query/89096/11 "2024-08-27T22:53:05Z")
Can you explain how you got this to work ? Screenshots would help. Thanks. ---
**Author:** ![SolarNomad](https://avatars.discourse-cdn.com/v4/letter/s/34f0e0/32.png) [@SolarNomad](https://forum.inductiveautomation.com/u/SolarNomad)\ **Post date:** [April 6, 2026, 10:24pm UTC](https://forum.inductiveautomation.com/t/timeseries-chart-using-nested-query/89096/12 "2026-04-06T22:24:01Z")
Ran into this myself and found that I needed to modify my DataKey. To use the above screenshot as an example the data key was changed to station name[0].sub\_query. Hope this helps anyone else running into similar issues