EasyGraph sql where clause dynamic

Ignition
1

I have an EasyGraph, is there a way to change the WHERE CLAUSE from a Button-Script?

thanks

{551CEA44-D72F-4109-97D1-49600D9B42E9}
{551CEA44-D72F-4109-97D1-49600D9B42E9}1050×661 108 KB

2

Yes, regenerate the pens dataset with a script. (Typically with system.dataset.setValue().)

3

If someone Need the code just to replace where clause in an specific DB pen ,in this case row 1 col 16 (which is the WHERE clause.)

chart = event.source.parent.getComponent('Easy ChartT')
tagPenDataSet = chart.pens
#print "Row Count = ", tagPenDataSet.rowCount, " Column Count = ", tagPenDataSet.columnCount,"\n"

newWhereClause = "Equip_ID = '221' and Wireline = '1'"

originalData = system.dataset.toPyDataSet(tagPenDataSet)
newData = system.dataset.setValue(originalData, 1, 16, newWhereClause)
chart.pens = newData