Quality rule - query 3

When you combine the same OPC quality then that OPC quality will be returned. However, when there is no good point in a cycle for cyclic modes such as Integral, Average, Counter, or AnalogSummary, the returned NULL value will have an OPC quality of 0 and a Quality Detail of 65536, regardless of combined qualities.

SELECT TagName, StartDateTime, EndDateTime, OPCQuality, PercentGood, wwRetrievalMode, first

FROM AnalogSummaryHistory

WHERE TagName = 'F0R5'

AND StartDateTime >= '2009-09-12 00:20'

AND EndDateTime <= '2009-09-12 00:40'

AND wwResolution = 10000

AND wwRetrievalMode = 'Cyclic'

If you run this query against the following sample data:

The results are: