Quality rule - query 7

The returned Quality Detail is the same as OPC quality unless there is special flag for certain indication; for example, when there is indication for rollover in counter mode.

SELECT TagName, DateTime, Value, QualityDetail, OPCQuality

FROM History

WHERE TagName = 'I0R5'

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

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

AND wwResolution = 10000

AND wwRetrievalMode = 'Avg'

If you run this query against the following sample data:

The results are: