ValueState retrieval query 4

The following query returns the total of time in state for a discrete tag. In this example, the TimeStampRule system parameter is set to "End" (the default setting), so the returned values are timestamped at the end of the cycle. The returned rows represent the time-in-state behavior during the period starting at 2005-04-13 00:00:00.000 and ending at 2005-04-14 00:00:00.000.

SELECT DateTime, vValue, StateTime, wwStateCalc FROM History

WHERE DateTime > '2005-04-13 00:00:00.000'

AND DateTime <= '2005-04-14 00:00:00.000'

AND TagName IN ('PumpStatus')

AND wwRetrievalMode = 'ValueState'

AND wwStateCalc = 'Total'

AND wwCycleCount = 1

The results are: