Quality rule - query 2

Similar to Quality rule - query 1, if you combine a mixture of doubtful OPC qualities, a doubtful OPC quality (64) will be returned as the combined OPC quality.

SELECT TagName, DateTime, Value, QualityDetail, OPCQuality, wwRetrievalMode

FROM History

WHERE TagName = 'I0R5'

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

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

AND wwResolution = 10000

AND wwRetrievalMode = 'Integral'

If you run this query against the following sample data:

The results are: