# Repeatedly calling chart charts

**URL:** <https://forum.inductiveautomation.com/t/repeatedly-calling-chart-charts/76445>\
**Category:** Ignition\
**Tags:** ignition81, vision\
**Created:** [July 17, 2023, 8:48am UTC](https://forum.inductiveautomation.com/t/repeatedly-calling-chart-charts/76445 "2023-07-17T08:48:28Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![chen\_zhe](https://avatars.discourse-cdn.com/v4/letter/c/c0e974/32.png) [@chen\_zhe](https://forum.inductiveautomation.com/u/chen_zhe)\
**Post date:** [July 17, 2023, 8:48am UTC](https://forum.inductiveautomation.com/t/repeatedly-calling-chart-charts/76445/1 "2023-07-17T08:48:28Z")

</div>

![aaa](https://us1.discourse-cdn.com/inductiveautomation/original/3X/0/e/0ef1cca38dbb47de04a8d0f155a7f4e587483dbc.png)  
 ![bbb](https://us1.discourse-cdn.com/inductiveautomation/original/3X/4/c/4c242d08dbf5cc2ed45827cd944557d4a3d2fae8.png)  

[https://us1.discourse-cdn.com/inductiveautomation/original/3X/a/b/ab4d9110c26467124d33401953b8f7964f405bb3.mp4](https://us1.discourse-cdn.com/inductiveautomation/original/3X/a/b/ab4d9110c26467124d33401953b8f7964f405bb3.mp4)
  
How to repeatedly call chart charts, similar to operating records。thanks

---

<div class="post-metadata">

**Author:** ![Emma\_Ngo](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/emma_ngo/32/44559_2.png) [@Emma\_Ngo](https://forum.inductiveautomation.com/u/Emma_Ngo)\
**Post date:** [July 19, 2023, 9:48pm UTC](https://forum.inductiveautomation.com/t/repeatedly-calling-chart-charts/76445/2 "2023-07-19T21:48:10Z")

</div>

Hi [chen\_zhe](https://forum.inductiveautomation.com/u/chen_zhe),  
It looks like when you reopen the popup, it pulls up the last tab that you have clicked on.

---

<div class="post-metadata">

**Author:** ![chen\_zhe](https://avatars.discourse-cdn.com/v4/letter/c/c0e974/32.png) [@chen\_zhe](https://forum.inductiveautomation.com/u/chen_zhe)\
**Post date:** [July 20, 2023, 10:25am UTC](https://forum.inductiveautomation.com/t/repeatedly-calling-chart-charts/76445/3 "2023-07-20T10:25:53Z")

</div>

hi emma  
i use sql server selectd the chart table ,but the sqltable "T\_time" is (bigint),how can i invert to (datetime),so i can Query the data by time

![1689848567991](https://us1.discourse-cdn.com/inductiveautomation/original/3X/2/6/26a40fe7101e8d631fb8056649111b0f1392dad9.png)  
 ![1689848614937](https://us1.discourse-cdn.com/inductiveautomation/original/3X/1/1/117480a635195cac71a726c98529f32ee65b54f4.png)

---

<div class="post-metadata">

**Author:** ![chen\_zhe](https://avatars.discourse-cdn.com/v4/letter/c/c0e974/32.png) [@chen\_zhe](https://forum.inductiveautomation.com/u/chen_zhe)\
**Post date:** [July 20, 2023, 10:27am UTC](https://forum.inductiveautomation.com/t/repeatedly-calling-chart-charts/76445/4 "2023-07-20T10:27:51Z")

</div>

my english is not verywell,could you help me the BIGINT to DATETIME in vision

---

<div class="post-metadata">

**Author:** ![chen\_zhe](https://avatars.discourse-cdn.com/v4/letter/c/c0e974/32.png) [@chen\_zhe](https://forum.inductiveautomation.com/u/chen_zhe)\
**Post date:** [July 20, 2023, 10:30am UTC](https://forum.inductiveautomation.com/t/repeatedly-calling-chart-charts/76445/5 "2023-07-20T10:30:42Z")

</div>

![WeChat Image_20230720182930](https://us1.discourse-cdn.com/inductiveautomation/original/3X/5/6/56d17e30279481e9ccc95697ba5a4e479d44f3a7.png)  
all the data on the one table,i want to Query the data by time

---

<div class="post-metadata">

**Author:** ![Emma\_Ngo](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/emma_ngo/32/44559_2.png) [@Emma\_Ngo](https://forum.inductiveautomation.com/u/Emma_Ngo)\
**Post date:** [July 20, 2023, 9:17pm UTC](https://forum.inductiveautomation.com/t/repeatedly-calling-chart-charts/76445/6 "2023-07-20T21:17:40Z")

</div>

Hi [chen\_zhe](https://forum.inductiveautomation.com/u/chen_zhe),

It looks like your are using the SQL query on your component binding. I recommend using the Tag history binding instead. It could do the Datetime format automatically for you. You could check out [this user manual link here](https://docs.inductiveautomation.com/display/DOC81/Tag+History+Bindings+in+Perspective).

---

<div class="post-metadata">

**Author:** ![chen\_zhe](https://avatars.discourse-cdn.com/v4/letter/c/c0e974/32.png) [@chen\_zhe](https://forum.inductiveautomation.com/u/chen_zhe)\
**Post date:** [July 21, 2023, 11:15am UTC](https://forum.inductiveautomation.com/t/repeatedly-calling-chart-charts/76445/7 "2023-07-21T11:15:56Z")

</div>

I want to make a template, all analog quantities only need this one CHART to read his own historical data, with the history history seems to be unable to do, can only read from the database.

---

<div class="post-metadata">

**Author:** ![Emma\_Ngo](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/emma_ngo/32/44559_2.png) [@Emma\_Ngo](https://forum.inductiveautomation.com/u/Emma_Ngo)\
**Post date:** [July 21, 2023, 9:12pm UTC](https://forum.inductiveautomation.com/t/repeatedly-calling-chart-charts/76445/8 "2023-07-21T21:12:42Z")

</div>

Hi [chen\_zhe](https://forum.inductiveautomation.com/u/chen_zhe),

What is the type of Database you are querying data from? You could find more information on converting timestamp to DateTime format in this [link](https://support.inductiveautomation.com/hc/en-us/articles/360047136252-Understanding-Tag-Historian-Timestamps).