# Dataset Tag read values

**URL:** <https://forum.inductiveautomation.com/t/dataset-tag-read-values/15102>\
**Category:** Ignition\
**Created:** [August 17, 2017, 8:56pm UTC](https://forum.inductiveautomation.com/t/dataset-tag-read-values/15102 "2017-08-17T20:56:12Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![MMaynard](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/mmaynard/32/3366_2.png) [@MMaynard](https://forum.inductiveautomation.com/u/MMaynard)\
**Post date:** [August 17, 2017, 8:56pm UTC](https://forum.inductiveautomation.com/t/dataset-tag-read-values/15102/1 "2017-08-17T20:56:12Z")

</div>

We currently have a dataset tag that is filled using a SQL Query.  
It works fine for binding to the elements of the array, but we cannot seem to get to the values using system.tag.read calls.  
in example on a button:

```auto
valToRead = system.tag.read("DatasetTag[ITEM1][0,8]").value

```

Brings the following error. Note the above tag path was built using the builtin tag browse on the script editor window.

```auto
ValueError: com.google.common.collect.ComputationException: com.inductiveautomation.ignition.common.sqltags.parser.TagPathFormatException: Illegal character '[' (Line 1 , Char 33)

```

---

<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:** [August 17, 2017, 9:26pm UTC](https://forum.inductiveautomation.com/t/dataset-tag-read-values/15102/2 "2017-08-17T21:26:59Z")

</div>

You’ll need to use `system.tag.read` to bring in the entire dataset, then `.getValueAt(row, col)`:

`system.tag.read("DatasetTagPath").value.getValueAt(0, 8)`

---

<div class="post-metadata">

**Author:** ![MMaynard](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/mmaynard/32/3366_2.png) [@MMaynard](https://forum.inductiveautomation.com/u/MMaynard)\
**Post date:** [August 17, 2017, 9:40pm UTC](https://forum.inductiveautomation.com/t/dataset-tag-read-values/15102/3 "2017-08-17T21:40:13Z")

</div>

Thanks,  
I figured as much and was already doing it similarly.  
Can we get the Tag browse filtered to not include the dataset elements?  
It gets tiresome answering calls about things like that lol

---

<div class="post-metadata">

**Author:** ![TruThat](https://avatars.discourse-cdn.com/v4/letter/t/ea666f/32.png) [@TruThat](https://forum.inductiveautomation.com/u/TruThat)\
**Post date:** [September 11, 2017, 10:07pm UTC](https://forum.inductiveautomation.com/t/dataset-tag-read-values/15102/4 "2017-09-11T22:07:18Z")

</div>

I am trying to do something similar but need help....I know it is a simple just cant can get the correct syntax.

# 

> data = system.tag.read("SLI/Charlotte/Bakery/Generic Case/14x8[Item Description Line 1]").value.getValueAt(0, 1)

> Getting Error: com.google.common.collect.ComputationException: com.inductiveautomation.ignition.common.sqltags.parser.TagPathFormatException: Illegal character '[' (Line 1 , Char 39)

 ![](https://us1.discourse-cdn.com/inductiveautomation/original/2X/8/8f47f804f759b7e1116d500db428bbdc63813061.png)

I want to be able to loop thru all the sub datasets.  
This is the path via CopyTagPath  
SLI/Charlotte/Bakery/Generic Case/14x8[Item Description Line 1][1, 4]

---

<div class="post-metadata">

**Author:** ![Kevin.Collins](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kevin.collins/32/13497_2.png) [@Kevin.Collins](https://forum.inductiveautomation.com/u/Kevin.Collins)\
**Post date:** [September 11, 2017, 11:55pm UTC](https://forum.inductiveautomation.com/t/dataset-tag-read-values/15102/5 "2017-09-11T23:55:08Z")

</div>

Give this a try:

```python
rowZeroItemDesc = system.tag.read("SLI/Charlotte/Bakery/Generic Case/14x8").value.getValueAt(0, "Item Description Line 1")

```

I’ve used this particular page from the docs quite a lot in the past, just in case you haven’t found it yet:  
[Working with Datasets](https://docs.inductiveautomation.com:8443/display/DOC79/Working+with+Datasets)

Hope this helps!

---

<div class="post-metadata">

**Author:** ![Efernan](https://avatars.discourse-cdn.com/v4/letter/e/9d8465/32.png) [@Efernan](https://forum.inductiveautomation.com/u/Efernan)\
**Post date:** [April 4, 2018, 7:00pm UTC](https://forum.inductiveautomation.com/t/dataset-tag-read-values/15102/6 "2018-04-04T19:00:47Z")

</div>

Symilar here. Client DataSet tag St020\_Data  
Running Ignition 7.7.2.  
tried :  
data = system.tag.read("[]/Client/Stations/St020\_Data").value  
FieldValue = data.getValueAt(0,1)

but get error :

Traceback (most recent call last):  
File “event:propertyChange”, line 16, in   
AttributeError: ‘int’ object has no attribute ‘getValueAt’

Ignition v7.7.2 (b2014121709)  
Java: Oracle Corporation 1.8.0\_60

Any ideas?