Daily retrieval - query example

To use the daily retrieval mode, set the following parameter in your query.

wwRetrievalMode = 'Daily'

For example, the following query returns the average for the analog tag 'ReactLevel'. Note that on the 2021-11-06, daylight saving time ends, so the resolution reflects that the cycle is 25 hours rather than 24.

SELECT StartDateTime, wwResolution, TagName, Average

FROM AnalogSummaryHistory

WHERE TagName = 'ReactLevel'

AND StartDateTime >= '2021-11-04 08:00:00am'

AND EndDateTime <= '2001-11-08 08:00:00am'

AND wwRetrievalMode = 'Daily'

The results are: