# Update automatic query

**URL:** <https://forum.inductiveautomation.com/t/update-automatic-query/46886>\
**Category:** Ignition\
**Tags:** ignition78, ignition79, ignition80, ignition81, database\
**Created:** [May 19, 2021, 1:15pm UTC](https://forum.inductiveautomation.com/t/update-automatic-query/46886 "2021-05-19T13:15:12Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![antonio.sanchez](https://avatars.discourse-cdn.com/v4/letter/a/a587f6/32.png) [@antonio.sanchez](https://forum.inductiveautomation.com/u/antonio.sanchez)\
**Post date:** [May 19, 2021, 1:15pm UTC](https://forum.inductiveautomation.com/t/update-automatic-query/46886/1 "2021-05-19T13:15:12Z")

</div>

Hello everybody

I am in the graphic form using a bar chart where I have the following query

```auto
SELECT CONVERT(VARCHAR, Fecha, 108),QTY FROM HistoricoContador WHere Linea = 'Linea_Disco' And FORMAT (Fecha, 'dd/MM/yyyy') = FORMAT (GETDATE, 'dd/MM/yyyy') AND CONVERT(VARCHAR, Fecha, 108) BETWEEN '06' AND '21'
ORDER BY ID

```

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/1/6/161a013d4ca5966e5967fa451f581ac35cebf6d1.png)

and I would like to see if there is any way to get it to run every hour to update the bar chart.

I have the query in the DATA properties

---

<div class="post-metadata">

**Author:** ![calimero100582](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/calimero100582/32/18630_2.png) [@calimero100582](https://forum.inductiveautomation.com/u/calimero100582)\
**Post date:** [May 19, 2021, 1:19pm UTC](https://forum.inductiveautomation.com/t/update-automatic-query/46886/2 "2021-05-19T13:19:34Z")

</div>

In Perspective or Vision, there is a polling rate that can be used, and can be set to 3600 seconds

---

<div class="post-metadata">

**Author:** ![antonio.sanchez](https://avatars.discourse-cdn.com/v4/letter/a/a587f6/32.png) [@antonio.sanchez](https://forum.inductiveautomation.com/u/antonio.sanchez)\
**Post date:** [May 19, 2021, 1:33pm UTC](https://forum.inductiveautomation.com/t/update-automatic-query/46886/3 "2021-05-19T13:33:14Z")

</div>

do you know how to?

---

<div class="post-metadata">

**Author:** ![calimero100582](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/calimero100582/32/18630_2.png) [@calimero100582](https://forum.inductiveautomation.com/u/calimero100582)\
**Post date:** [May 19, 2021, 1:35pm UTC](https://forum.inductiveautomation.com/t/update-automatic-query/46886/4 "2021-05-19T13:35:25Z")

</div>

Vision

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/b/2/b2f91c52e83d5e72f41fe9290b7d5e032d2ff858.png)

Perspective

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/f/5/f50f3b4a84589da4364b7ec6f517cbbb1a6e6ac6.png)