# Named query returning multiples columns with a label in Vision

**URL:** <https://forum.inductiveautomation.com/t/named-query-returning-multiples-columns-with-a-label-in-vision/54937>\
**Category:** Ignition\
**Created:** [January 12, 2022, 4:56pm UTC](https://forum.inductiveautomation.com/t/named-query-returning-multiples-columns-with-a-label-in-vision/54937 "2022-01-12T16:56:11Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![vrautomation](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/vrautomation/32/11155_2.png) [@vrautomation](https://forum.inductiveautomation.com/u/vrautomation)\
**Post date:** [January 12, 2022, 4:56pm UTC](https://forum.inductiveautomation.com/t/named-query-returning-multiples-columns-with-a-label-in-vision/54937/1 "2022-01-12T16:56:11Z")

</div>

Hello everyone!

Simple question here.

I have a label calling a named query, calling a store procedure. The storeproc return a single row with multiples columns.

Is there a way to show the data of a particular column in the label?

Thanks,

---

<div class="post-metadata">

**Author:** ![lrose](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/lrose/32/62724_2.png) [@lrose](https://forum.inductiveautomation.com/u/lrose)\
**Post date:** [January 12, 2022, 5:09pm UTC](https://forum.inductiveautomation.com/t/named-query-returning-multiples-columns-with-a-label-in-vision/54937/2 "2022-01-12T17:09:03Z")

</div>

In Vision:  
Not with a direct binding.

Consider adding a custom property of Dataset type, and then use the `lookup()` expression in an expression binding to pull the data from the column you want.

In perspective:  
You can use a transform to pull the data as needed.

---

<div class="post-metadata">

**Author:** ![awaege1](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/awaege1/32/28922_2.png) [@awaege1](https://forum.inductiveautomation.com/u/awaege1)\
**Post date:** [January 12, 2022, 5:09pm UTC](https://forum.inductiveautomation.com/t/named-query-returning-multiples-columns-with-a-label-in-vision/54937/3 "2022-01-12T17:09:11Z")

</div>

Set the return type of the named query binding to be “Json”. Then call the desired column like you would a dictionary object using a script transform

```auto
jsonObject['dataColumn']

```

---

<div class="post-metadata">

**Author:** ![awaege1](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/awaege1/32/28922_2.png) [@awaege1](https://forum.inductiveautomation.com/u/awaege1)\
**Post date:** [January 12, 2022, 5:10pm UTC](https://forum.inductiveautomation.com/t/named-query-returning-multiples-columns-with-a-label-in-vision/54937/4 "2022-01-12T17:10:45Z")

</div>

Wait nevermind. This is in vision. In that case you could just select the single column in the named query or SP and then create the named query as Scalar

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [January 12, 2022, 5:11pm UTC](https://forum.inductiveautomation.com/t/named-query-returning-multiples-columns-with-a-label-in-vision/54937/5 "2022-01-12T17:11:08Z")

</div>

No lookup required if only a single row. The expression would be:

```auto
try({path.to.dataset.custom.property}[0,'ColumnName'], 'someFallback value')

```

The `try()` covers the case of zero rows returned.

---

<div class="post-metadata">

**Author:** ![vrautomation](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/vrautomation/32/11155_2.png) [@vrautomation](https://forum.inductiveautomation.com/u/vrautomation)\
**Post date:** [January 12, 2022, 5:15pm UTC](https://forum.inductiveautomation.com/t/named-query-returning-multiples-columns-with-a-label-in-vision/54937/6 "2022-01-12T17:15:09Z")

</div>

Problem solved! I really love Ignition 🙂