# The following example will return a dataset with one row detailing maximum value of a Tag named 'Sine' for the past 30 minutes.
endTime = system.date.now()
startTime = system.date.addDays (endTime, -20)
#print startTime
#[Laboratory]炉上温
path =u'[Laboratory]炉上温'
dataSet = system.tag.queryTagHistory(paths=[path], startDate=startTime, endDate=endTime, returnSize=1, aggregationMode="Maximum", returnFormat='Wide')
print dataSet
pyData = system.dataset.toPyDataSet(dataSet)
for row in pyData:
for value in row:
print value
One small problem: system.tag.queryTagHistory | Ignition User Manual says it should be
aggregationModes="Maximum"
and not
aggregationMode="Maximum"
.
I don't know if that is enough to fix it.
Tag History , stroe mode is onchange.
Sql store:
now value =77 , store value=98
start = system.date.parse(system.date.addMinutes(system.date.now(), -2))
end = system.date.now()
aggregationMode = ["Average","Sum","MinMax","LastValue","SimpleAverage","Range"]
paths = ['[Laboratory]TestTag222']
dataset = system.tag.queryTagHistory(paths=paths, aggregationMode="Average", startDate= start, endData=end)
pydataset= system.dataset.toPyDataSet(dataset)
for row in range(pydataset.getRowCount()):
for col in range(pydataset.getColumnCount()):
print pydataset.getValueAt(row, col)
get result:
How to get 98?