Minimum retrieval - query 1

In this example, an analog tag is retrieved over a five minute period, using the minimum retrieval mode. Because the wwResolution parameter is set to 60000, each cycle is exactly one minute long. The minimum data value is returned from each of these cycles.

SELECT DateTime, TagName, CONVERT(DECIMAL(10, 2), Value) AS Value FROM History

WHERE TagName = 'ReactTemp'

AND DateTime >= '2005-04-11 11:21:00'

AND DateTime <= '2005-04-11 11:26:00'

AND wwRetrievalMode = 'Minimum'

AND wwResolution = 60000

The initial value at the query start time is the minimum value found in the phantom cycle before the start time of the query.

The results are: