mysql> SELECT * FROM idata_134 WHERE item_id=26;
+---------+-----------------+-------------+
| item_id | idata_timestamp | idata_value |
+---------+-----------------+-------------+
| 26 | 1381494998 | 22 |
| 26 | 1381495238 | 22 |
| 26 | 1381495478 | 22 |
| 26 | 1381495718 | 22 |
| 26 | 1381495958 | 22 |
| 26 | 1381496198 | 22 |
| 26 | 1381496438 | 22 |
| 26 | 1381496678 | 22 |
| 26 | 1381496918 | 22 |
| 26 | 1381497158 | 22 |
| 26 | 1381497398 | 22 |
| 26 | 1381497638 | 22 |
| 26 | 1381497878 | 22 |
| 26 | 1381498118 | 22 |
+---------+-----------------+-------------+
14 rows in set (0.00 sec)
mysql> SELECT avg(coalesce(idata_value,0)) FROM idata_134 WHERE item_id=26 and idata_timestamp between 1381494998 and 1381497638;
+------------------------------+
| avg(coalesce(idata_value,0)) |
+------------------------------+
| 22 |
+------------------------------+
1 row in set (0.00 sec)
Script:
startTime = 1381494998;
stopTime = 1381497638;
object = FindNodeObject(null,"TERM1");
trace(0, "*** VALUE: " . GetAvgDCIValue(object, FindDCIByDescription(object,"npThermoValue"), startTime, stopTime));
trace(0, "*** MAX: " . GetMaxDCIValue(object, FindDCIByDescription(object,"npThermoValue"), startTime, stopTime));
trace(0, "*** MIN: " . GetMinDCIValue(object, FindDCIByDescription(object,"npThermoValue"), startTime, stopTime));
Result:
[11-Oct-2013 17:34:24.413] [INFO ] *** VALUE: 2.000000
[11-Oct-2013 17:34:24.414] [INFO ] *** MAX: 22.000000
[11-Oct-2013 17:34:24.414] [INFO ] *** MIN: 22.000000