# Filtering results of a dataset

**URL:** <https://forum.inductiveautomation.com/t/filtering-results-of-a-dataset/3807>\
**Category:** Ignition\
**Created:** [December 23, 2011, 2:49pm UTC](https://forum.inductiveautomation.com/t/filtering-results-of-a-dataset/3807 "2011-12-23T14:49:13Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![diat150](https://avatars.discourse-cdn.com/v4/letter/d/a587f6/32.png) [@diat150](https://forum.inductiveautomation.com/u/diat150)\
**Post date:** [December 23, 2011, 2:49pm UTC](https://forum.inductiveautomation.com/t/filtering-results-of-a-dataset/3807/1 "2011-12-23T14:49:13Z")

</div>

Lets say I run this code to populate a table with battery voltages:

[code]query = “SELECT displayname, devicename from devices”

if event.propertyName in [“devices”, “refresh”]:  
table = event.source.getComponent(‘Table’)  
newData = []  
header = [“Displayname”, “Identifier”, “Battery Voltage”]  
res = system.db.runQuery(query)  
tagPaths = []

for row in res:  
tagPath = row[1]

```
   tagPaths.append("%s/Volts"%tagPath)

```

results = system.tag.getTagValues(tagPaths)

idx = 0  
for row in res:  
displayName = row[0]  
tagPath = row[1]  
newData.append([displayName, tagPath, results[0+idx]])  
idx += 1

table.data = system.dataset.toDataSet(header, newData)[/code]

Is there a way for me to add a filter to show only results that are \<12?

---

<div class="post-metadata">

**Author:** ![JordanCClark](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jordancclark/32/83362_2.png) [@JordanCClark](https://forum.inductiveautomation.com/u/JordanCClark)\
**Post date:** [December 23, 2011, 2:53pm UTC](https://forum.inductiveautomation.com/t/filtering-results-of-a-dataset/3807/2 "2011-12-23T14:53:50Z")

</div>

How about this:

[code]  
idx = 0  
for row in res:  
displayName = row[0]  
tagPath = row[1]  
if results[0+idx]\<12:  
newData.append([displayName, tagPath, results[0+idx]])  
idx += 1

table.data = system.dataset.toDataSet(header, newData)[/code]

---

<div class="post-metadata">

**Author:** ![diat150](https://avatars.discourse-cdn.com/v4/letter/d/a587f6/32.png) [@diat150](https://forum.inductiveautomation.com/u/diat150)\
**Post date:** [December 23, 2011, 3:10pm UTC](https://forum.inductiveautomation.com/t/filtering-results-of-a-dataset/3807/3 "2011-12-23T15:10:51Z")

</div>

well that was easy! thanks.