Quality rule - query 4
- Last UpdatedFeb 07, 2025
- 1 minute read
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'
If you run this query against the following sample data:
|
Tagname |
DateTime |
Resolution |
QualityDetail |
|---|---|---|---|
|
F0R5 |
2009-09-12 00:07 |
1.6 |
15 |
|
F0R5 |
2009-09-12 00:14 |
3.1 |
15 |
|
F0R5 |
2009-09-12 00:22 |
0.2 |
15 |
|
F0R5 |
2009-09-12 00:25 |
0.8 |
15 |
|
F0R5 |
2009-09-12 00:27 |
0.4 |
15 |
|
F0R5 |
2009-09-12 00:29 |
2.2 |
15 |
|
F0R5 |
2009-09-12 00:33 |
3.3 |
15 |
|
F0R5 |
2009-09-12 00:36 |
0.3 |
15 |
|
F0R5 |
2009-09-12 00:39 |
1.2 |
15 |
The results are:
|
Tagname |
DateTime |
Value |
QualityDetail |
OPCQuality |
wwRetrievalMode |
|---|---|---|---|---|---|
|
F0R5 |
2009-09-12 00:20 |
NULL |
65536 |
0 |
AVERAGE |
|
F0R5 |
2009-09-12 00:30 |
NULL |
65536 |
0 |
AVERAGE |
|
F0R5 |
2009-09-12 00:40 |
NULL |
65536 |
0 |
AVERAGE |