Minimum retrieval - query 3

This example shows how the minimum retrieval mode marks the QualityDetail column to indicate that a minimum value is returned based on an incomplete cycle. In this case, an incomplete cycle is a cycle that either contained periods with no values stored or a cycle that was cut short because the query end time was located inside the cycle. All values returned for the QualityDetail column are documented in the QualityMap table in the Runtime database.

SELECT DateTime, TagName, Value, QualityDetail FROM History

WHERE TagName = 'SysTimeSec'

AND DateTime >= '2005-04-11 11:18:50'

AND DateTime <= '2005-04-11 11:20:50'

AND wwRetrievalMode = 'Minimum'

AND wwResolution = 60000

The results are: