# Trending data stored using system.tag.storeTagHistory

**URL:** <https://forum.inductiveautomation.com/t/trending-data-stored-using-system-tag-storetaghistory/17788>\
**Category:** Ignition\
**Created:** [April 20, 2018, 1:02pm UTC](https://forum.inductiveautomation.com/t/trending-data-stored-using-system-tag-storetaghistory/17788 "2018-04-20T13:02:30Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![AlThePal](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/althepal/32/3603_2.png) [@AlThePal](https://forum.inductiveautomation.com/u/AlThePal)\
**Post date:** [April 20, 2018, 1:02pm UTC](https://forum.inductiveautomation.com/t/trending-data-stored-using-system-tag-storetaghistory/17788/1 "2018-04-20T13:02:30Z")

</div>

I’m writing to the Ignition history tables using _system.tag.storeTagHistory_ from a gateway timer script. This seems to work OK and I can interrogate the data using _system.tag.queryTagHistory_.

What I can’t do is trend any of the data using an Easy Chart. Tags stored in the same history table using Tag History work, but not those stored using _storeTagHistory_.

Any ideas on what I’m missing?

---

<div class="post-metadata">

**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 20, 2018, 1:12pm UTC](https://forum.inductiveautomation.com/t/trending-data-stored-using-system-tag-storetaghistory/17788/2 "2018-04-20T13:12:51Z")

</div>

Have you tried generating a row in tagPens by hand? It might be a drag/drop limitation.

---

<div class="post-metadata">

**Author:** ![AlThePal](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/althepal/32/3603_2.png) [@AlThePal](https://forum.inductiveautomation.com/u/AlThePal)\
**Post date:** [April 20, 2018, 2:30pm UTC](https://forum.inductiveautomation.com/t/trending-data-stored-using-system-tag-storetaghistory/17788/3 "2018-04-20T14:30:48Z")

</div>

I’ve tried that but no improvement. I also tried reading data into a standard Chart using the Tag History interface - again this shows data for the tags recorded using Tag History but not for tags recorded using _storeTagHistory_.

---

<div class="post-metadata">

**Author:** ![MMaynard](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/mmaynard/32/3366_2.png) [@MMaynard](https://forum.inductiveautomation.com/u/MMaynard)\
**Post date:** [April 20, 2018, 3:17pm UTC](https://forum.inductiveautomation.com/t/trending-data-stored-using-system-tag-storetaghistory/17788/4 "2018-04-20T15:17:40Z")

</div>

Have you done a query against the actual table in the database?  
I would query a working tag and an non working tag and compare the differences between them.

> SELECT [tagid]  
> ,[intvalue]  
> ,[floatvalue]  
> ,[stringvalue]  
> ,[datevalue]  
> ,[dataintegrity]  
> ,[t\_stamp]  
> FROM [IGN].[dbo].[sqlt\_data\_1\_2018\_04]  
> WHERE [tagid]=123  
> OR [tagid]=321

Also query against the sqlth\_te table to see if there is something different between the tags in there as well.

> SELECT [id]  
> ,[tagpath]  
> ,[scid]  
> ,[datatype]  
> ,[querymode]  
> ,[created]  
> ,[retired]  
> FROM [IGN].[dbo].[sqlth\_te]  
> WHERE [id]=123 or [id]=321  
> AND retired is null

Where 123 is the working tag id and 321 is the non working tagid

---

<div class="post-metadata">

**Author:** ![AlThePal](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/althepal/32/3603_2.png) [@AlThePal](https://forum.inductiveautomation.com/u/AlThePal)\
**Post date:** [April 20, 2018, 3:45pm UTC](https://forum.inductiveautomation.com/t/trending-data-stored-using-system-tag-storetaghistory/17788/5 "2018-04-20T15:45:44Z")

</div>

There aren’t any obvious differences in the SQL tables. It looks like something internal to Ignition.

---

<div class="post-metadata">

**Author:** ![AlThePal](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/althepal/32/3603_2.png) [@AlThePal](https://forum.inductiveautomation.com/u/AlThePal)\
**Post date:** [April 20, 2018, 6:12pm UTC](https://forum.inductiveautomation.com/t/trending-data-stored-using-system-tag-storetaghistory/17788/6 "2018-04-20T18:12:44Z")

</div>

Anthony from Tech Support helped solve this one.

It turns out in both the Easy Chart and the original Chart you have to specify the fully-qualified path to the tag. This means instead of

`[~]ramp`

you will have something like

`[project_name/ignition_system_name:historical_tag_provider]ramp`

In both the Easy Chart and original Chart (when using Tag History) there is a `Use Fully-qualified paths` option when you are choosing the tag.