Average retrieval - query 2
- Last UpdatedFeb 06, 2025
- 1 minute read
This query demonstrates the use of the average retrieval mode in a wide query. Time-weighted average values are returned for the analog tags ReactTemp and ReactLevel, while regular cyclic points are returned for the discrete tag, WaterValve.
SELECT * FROM OpenQuery(INSQL,
'SELECT DateTime, ReactTemp, ReactLevel, WaterValve FROM WideHistory
WHERE DateTime >= "2004-06-07 08:00"
AND DateTime < "2004-06-07 08:05"
AND wwRetrievalMode = "Average"
AND wwCycleCount = 5
')
The results are:
|
DateTime |
ReactTemp |
ReactLevel |
WaterValve |
|---|---|---|---|
|
2004-06-07 08:00:00.000 |
47.71621 |
1676.69716 |
1 |
|
2004-06-07 08:01:00.000 |
157.28076 |
1370.88097 |
0 |
|
2004-06-07 08:02:00.000 |
41.33734 |
797.67296 |
1 |
|
2004-06-07 08:03:00.000 |
122.99525 |
1921.66771 |
0 |
|
2004-06-07 08:04:00.000 |
105.28866 |
606.40488 |
1 |