# Learning to use the queries

**URL:** <https://forum.inductiveautomation.com/t/learning-to-use-the-queries/51005>\
**Category:** Ignition\
**Created:** [September 15, 2021, 3:27pm UTC](https://forum.inductiveautomation.com/t/learning-to-use-the-queries/51005 "2021-09-15T15:27:47Z")\
**Posts on this page:** 1\
**Showing post:** 29

<div class="post-metadata">

**Author:** ![jlandwerlen](https://avatars.discourse-cdn.com/v4/letter/j/bc8723/32.png) [@jlandwerlen](https://forum.inductiveautomation.com/u/jlandwerlen)\
**Post date:** [November 2, 2021, 6:49pm UTC](https://forum.inductiveautomation.com/t/learning-to-use-the-queries/51005/29 "2021-11-02T18:49:15Z")

</div>

> [@zacharyw.larson](#):
>
> I am not sure when I should reset the values or if I let them rollover.  
> I am going to work with someone to find out what their experience says or hope for a post.

This topic came up just today. See this post, @JordanCClark shows a script that will handle resets or rollovers.

> [@Calculation of consumption when counter reset to zero](https://forum.inductiveautomation.com/t/calculation-of-consumption-when-counter-reset-to-zero/52611/5):
>
> MSSQL server 2012

---

_[View the full topic](https://forum.inductiveautomation.com/t/learning-to-use-the-queries/51005)._