Bounding - query example
- Last UpdatedMar 19, 2025
- 1 minute read
This example illustrates using the bounding option. First, consider this query, run on a tag that returns data at 3 minute intervals:
SELECT DateTime, Value, Quality, OPCQuality
FROM History
WHERE TagName = 'Pump106.flow'
AND wwRetrievalMode = 'Full'
AND DateTime >= '2022-07-06 07:00:00.000'
AND DateTime <= '2022-07-06 07:09:00.000'
AND wwOption = 'Bounding'
The results are:
|
DateTime |
Value |
Quality |
OPCQuality |
|---|---|---|---|
|
2022-07-06 06:58:00.000 |
76.29 |
0 |
192 |
|
2022-07-06 07:01:00.000 |
74.35 |
0 |
192 |
|
2022-07-06 07:04:00.000 |
72.47 |
0 |
192 |
|
2022-07-06 07:07:00.000 |
73.84 |
0 |
192 |
|
2022-07-06 07:10:00.000 |
75.62 |
0 |
192 |