ValueState retrieval query 1: minimum time in state

The following query finds the minimum time-in-state for the SteamValve discrete tag. Note that minimum times are returned for each state for both the five-minute phantom cycle before the query start time and for the single retrieval cycle between 10:00 and 10:05.

SELECT DateTime, TagName, vValue, StateTime, wwStateCalc FROM History

WHERE TagName IN ('SteamValve')

AND DateTime >= '2005-04-17 10:00:00'

AND DateTime <= '2005-04-17 10:05:00'

AND wwCycleCount = 1

AND wwRetrievalMode = 'ValueState'

AND wwStateCalc = 'Min'

The results are: