# getDataset from root container

**URL:** <https://forum.inductiveautomation.com/t/getdataset-from-root-container/29796>\
**Category:** Ignition\
**Tags:** ignition79\
**Created:** [November 8, 2019, 6:49pm UTC](https://forum.inductiveautomation.com/t/getdataset-from-root-container/29796 "2019-11-08T18:49:17Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![boster281](https://avatars.discourse-cdn.com/v4/letter/b/ea666f/32.png) [@boster281](https://forum.inductiveautomation.com/u/boster281)\
**Post date:** [November 8, 2019, 6:49pm UTC](https://forum.inductiveautomation.com/t/getdataset-from-root-container/29796/1 "2019-11-08T18:49:17Z")

</div>

I made a root container dataset property to query a database and get all of my data for a part.  
I tried to use getDatasetValueByName in an expression on a label to get a value out of the root container dataset that i created but that seems to be the wrong implementation of that.

So may question is how can I get specific data out of a custom property dataset?

---

<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:** [November 8, 2019, 7:20pm UTC](https://forum.inductiveautomation.com/t/getdataset-from-root-container/29796/2 "2019-11-08T19:20:17Z")

</div>

Just put row and column in square brackets in your binding expression after the property reference. I generally include the try() function to catch missing datasets during startup. Something like this for the value in the first row, first column:

```auto
try({Root Container.SomeProperty}[0, 0], 0)

```

The row and column can be other properties, of course. And the column can be a string column name instead of an index.

---

<div class="post-metadata">

**Author:** ![boster281](https://avatars.discourse-cdn.com/v4/letter/b/ea666f/32.png) [@boster281](https://forum.inductiveautomation.com/u/boster281)\
**Post date:** [November 8, 2019, 8:23pm UTC](https://forum.inductiveautomation.com/t/getdataset-from-root-container/29796/3 "2019-11-08T20:23:42Z")

</div>

That works perfect.

Where is this in the help file, so next time I have an idea where to look.

---

<div class="post-metadata">

**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\
**Post date:** [November 8, 2019, 9:10pm UTC](https://forum.inductiveautomation.com/t/getdataset-from-root-container/29796/4 "2019-11-08T21:10:17Z")

</div>

[https://docs.inductiveautomation.com/display/DOC80/Expression+Overview+and+Syntax#ExpressionOverviewandSyntax-DatasetAccess](https://docs.inductiveautomation.com/display/DOC80/Expression+Overview+and+Syntax#ExpressionOverviewandSyntax-DatasetAccess)