# Named Query Scalar Result

**URL:** <https://forum.inductiveautomation.com/t/named-query-scalar-result/18911>\
**Category:** Ignition\
**Created:** [July 20, 2018, 1:49pm UTC](https://forum.inductiveautomation.com/t/named-query-scalar-result/18911 "2018-07-20T13:49:15Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![dkhayes117](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/dkhayes117/32/68344_2.png) [@dkhayes117](https://forum.inductiveautomation.com/u/dkhayes117)\
**Post date:** [July 20, 2018, 1:49pm UTC](https://forum.inductiveautomation.com/t/named-query-scalar-result/18911/1 "2018-07-20T13:49:15Z")

</div>

I have a named query that takes two parameters, the query returns a single value but is still a dataset. Whats the easiest way to get that value as a scalar value?

---

<div class="post-metadata">

**Author:** ![KathyApplebaum](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kathyapplebaum/32/7261_2.png) [@KathyApplebaum](https://forum.inductiveautomation.com/u/KathyApplebaum)\
**Post date:** [July 20, 2018, 1:50pm UTC](https://forum.inductiveautomation.com/t/named-query-scalar-result/18911/2 "2018-07-20T13:50:08Z")

</div>

Did you make the type of the query scalar?

---

<div class="post-metadata">

**Author:** ![dkhayes117](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/dkhayes117/32/68344_2.png) [@dkhayes117](https://forum.inductiveautomation.com/u/dkhayes117)\
**Post date:** [July 20, 2018, 1:53pm UTC](https://forum.inductiveautomation.com/t/named-query-scalar-result/18911/3 "2018-07-20T13:53:59Z")

</div>

I knew there was a simple solution I was missing, I just couldn’t remember what it was. Thanks!