Quality rule - query 5

When you combine a mixture of good, bad, and uncertain OPC qualities, a doubtful OPC quality (64) will be returned as a combined result.

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

FROM History

WHERE TagName = 'F0R5'

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

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

AND wwResolution = 10000

AND wwRetrievalMode = 'Avg'

AND wwQualityRule = 'Optimistic'

If you run this query against the following sample data:

The results are: