# Working/Binding Datasets in perspective

**URL:** <https://forum.inductiveautomation.com/t/working-binding-datasets-in-perspective/21927>\
**Category:** Ignition Early Access\
**Created:** [January 16, 2019, 9:46pm UTC](https://forum.inductiveautomation.com/t/working-binding-datasets-in-perspective/21927 "2019-01-16T21:46:49Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![javier.jimenez](https://avatars.discourse-cdn.com/v4/letter/j/43a26b/32.png) [@javier.jimenez](https://forum.inductiveautomation.com/u/javier.jimenez)\
**Post date:** [January 16, 2019, 9:46pm UTC](https://forum.inductiveautomation.com/t/working-binding-datasets-in-perspective/21927/1 "2019-01-16T21:46:49Z")

</div>

Hello,

Anyone can help me? I use vision for create HMI, in there we have tag from query tag (SQL Database). finally we have a Dataset. At root container we add new custom properties called “Data”, this is equal to Dataset from Query tag. when we add new components we use binding expression

```auto
{RootContainer.Data[row,colum]}

```

Now, in perspective anyone can help me to binding one field of Dataset using expression or similar?

Thanks for your time

---

<div class="post-metadata">

**Author:** ![andrewbrown](https://avatars.discourse-cdn.com/v4/letter/a/a8b319/32.png) [@andrewbrown](https://forum.inductiveautomation.com/u/andrewbrown)\
**Post date:** [January 17, 2019, 4:32am UTC](https://forum.inductiveautomation.com/t/working-binding-datasets-in-perspective/21927/2 "2019-01-17T04:32:50Z")

</div>

One quick way would be to use a Script Transform and do the following:

```auto
field = value.getValueAt(row, col)

```

value being the incoming value from the binding to the dataset.

Hope that helps.

---

<div class="post-metadata">

**Author:** ![javier.jimenez](https://avatars.discourse-cdn.com/v4/letter/j/43a26b/32.png) [@javier.jimenez](https://forum.inductiveautomation.com/u/javier.jimenez)\
**Post date:** [January 21, 2019, 7:40pm UTC](https://forum.inductiveautomation.com/t/working-binding-datasets-in-perspective/21927/3 "2019-01-21T19:40:19Z")

</div>

here we look the Dataset Tag value. try the previous doesn´t work. We just need insert value.value into a numeric label or led display.

Can you help me?

Thanks for your time.

 ![dataset](https://us1.discourse-cdn.com/inductiveautomation/original/2X/a/af299cfeaaecea7e900d6d539f39e64d75a261f3.png)

---

<div class="post-metadata">

**Author:** ![andrewbrown](https://avatars.discourse-cdn.com/v4/letter/a/a8b319/32.png) [@andrewbrown](https://forum.inductiveautomation.com/u/andrewbrown)\
**Post date:** [January 21, 2019, 9:02pm UTC](https://forum.inductiveautomation.com/t/working-binding-datasets-in-perspective/21927/4 "2019-01-21T21:02:48Z")

</div>

not sure what youve done wrong if it doesnt work. this is setup on a custom property however it makes no difference on a numeric field.

May I ask why you are storing values in a dataset tag rather then in another method?

 ![06%20am](https://us1.discourse-cdn.com/inductiveautomation/original/2X/8/89d7063c34ea21a7628c583887206823f844c75b.png)

---

<div class="post-metadata">

**Author:** ![javier.jimenez](https://avatars.discourse-cdn.com/v4/letter/j/43a26b/32.png) [@javier.jimenez](https://forum.inductiveautomation.com/u/javier.jimenez)\
**Post date:** [January 22, 2019, 2:42pm UTC](https://forum.inductiveautomation.com/t/working-binding-datasets-in-perspective/21927/5 "2019-01-22T14:42:29Z")

</div>

Thank you, it´s working now…

we use dataset because we make a SQL Query from database, multi row, so the application is running at Ignition visión 7.9 and mobile… we are testing perspective for migration.

Thanks for your time