How not display lines containing zeros in a Power table (dataset)

[jlandwerlen]

Some hints:

Filtering results of a dataset

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: displayNa…

Named Query, Power table, Row color based off column value

This should be fairly easy however I am quite new at this, scoured the forms and much of what I’ve found is quite vague. I have a power table running a named query that updates every 5 min. I would like to change the row colors based on the value in column 8. The values in column 8 go up to 400. From 0-90 I would like the row to be red, from 90-120 the row yellow, from 120-400 green. I have tried various scripts in the configureCell to no avail. Can this be done by binding in the Backgroun…