# Named query column as a text field in Perspective

**URL:** <https://forum.inductiveautomation.com/t/named-query-column-as-a-text-field-in-perspective/69203>\
**Category:** Ignition\
**Tags:** perspective\
**Created:** [January 31, 2023, 11:08am UTC](https://forum.inductiveautomation.com/t/named-query-column-as-a-text-field-in-perspective/69203 "2023-01-31T11:08:22Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Matabufalez](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/matabufalez/32/42267_2.png) [@Matabufalez](https://forum.inductiveautomation.com/u/Matabufalez)\
**Post date:** [January 31, 2023, 11:08am UTC](https://forum.inductiveautomation.com/t/named-query-column-as-a-text-field-in-perspective/69203/1 "2023-01-31T11:08:22Z")

</div>

Good morning,  
I still crashing into walls while trying to learn about this enviroment. Perspective seems to be very powerfull but I am missing some options which in "Reports" enviroment are quite easy.  
I just want to use the columns of a Named Query (1 row) as a Text Field and update it periodically.

How can I pick this values without headers?  
Seems more difficult than it seems...

Thank you

---

<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 31, 2023, 1:04pm UTC](https://forum.inductiveautomation.com/t/named-query-column-as-a-text-field-in-perspective/69203/2 "2023-01-31T13:04:14Z")

</div>

You use an expression binding. There, you are allowed to provide row and column subscripts to a reference containing a dataset. Something like:

```auto
{path.to.dataset.prop.or.tag}[0,0]

```

The column can be given as a quoted column name, too.

---

<div class="post-metadata">

**Author:** ![Matabufalez](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/matabufalez/32/42267_2.png) [@Matabufalez](https://forum.inductiveautomation.com/u/Matabufalez)\
**Post date:** [January 31, 2023, 2:09pm UTC](https://forum.inductiveautomation.com/t/named-query-column-as-a-text-field-in-perspective/69203/3 "2023-01-31T14:09:25Z")

</div>

Thank you, so simple!!