# Tag History Query - Scripting - Single Closest Value

**URL:** <https://forum.inductiveautomation.com/t/tag-history-query-scripting-single-closest-value/16734>\
**Category:** Ignition\
**Tags:** ignition79, scripting\
**Created:** [January 25, 2018, 3:16pm UTC](https://forum.inductiveautomation.com/t/tag-history-query-scripting-single-closest-value/16734 "2018-01-25T15:16:12Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![bfuson](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/bfuson/32/4597_2.png) [@bfuson](https://forum.inductiveautomation.com/u/bfuson)\
**Post date:** [January 25, 2018, 3:16pm UTC](https://forum.inductiveautomation.com/t/tag-history-query-scripting-single-closest-value/16734/1 "2018-01-25T15:16:13Z")

</div>

I’m attempting to query for the historical value of an integer tag at one single point in time, but am drawing a blank since “ClosestValue” is not available as an aggregation mode through scripting.

Found a similar question but no responses: [History tag, single value?](http://forum.inductiveautomation.com/t/history-tag-single-value/11308)

Any ideas, or am I trying something that shouldn’t be necessary?

Thanks!

---

<div class="post-metadata">

**Author:** ![bfuson](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/bfuson/32/4597_2.png) [@bfuson](https://forum.inductiveautomation.com/u/bfuson)\
**Post date:** [January 25, 2018, 3:39pm UTC](https://forum.inductiveautomation.com/t/tag-history-query-scripting-single-closest-value/16734/2 "2018-01-25T15:39:29Z")

</div>

Some additional details:

The integer is essentially a code or enum for a machines status.  
The historian properties are as follows:

- Deadband = 1.0
- Deadband Mode = Absolute
- Max time between records = Unlimited
- Timestamp Source = System
- Value Mode = Discrete

I’m not sure if the historian is the best way to store this information, or if I’d be better off using my own SQL tables and on-change event scripts.

---

<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:** [January 25, 2018, 4:30pm UTC](https://forum.inductiveautomation.com/t/tag-history-query-scripting-single-closest-value/16734/3 "2018-01-25T16:30:46Z")

</div>

LastValue is the scripting equivalent of Closest Value.

[https://docs.inductiveautomation.com/display/DOC79/system.tag.queryTagHistory](https://docs.inductiveautomation.com/display/DOC79/system.tag.queryTagHistory)