Value deadband - query 1
- Last UpdatedFeb 07, 2025
- 1 minute read
This query specifies to return only data that changed by more than 10 percent of the tag's full engineering unit range. Using a value deadband of 10 percent equates to an absolute change of 5.9 for 'SysTimeSec.'
SELECT DateTime, Value
FROM History
WHERE TagName = 'SysTimeSec'
AND DateTime >= '2001-12-09 11:35'
AND DateTime <= '2001-12-09 11:37'
AND wwRetrievalMode = 'Delta'
AND wwValueDeadband = 10
The results are:
|
DateTime |
Value |
|
2001-12-09 11:35:00.000 |
0 |
|
2001-12-09 11:35:06.000 |
6 |
|
2001-12-09 11:35:12.000 |
12 |
|
2001-12-09 11:35:18.000 |
18 |
|
2001-12-09 11:35:24.000 |
24 |
|
2001-12-09 11:35:30.000 |
30 |
|
2001-12-09 11:35:36.000 |
36 |
|
2001-12-09 11:35:42.000 |
42 |
|
2001-12-09 11:35:48.000 |
48 |
|
2001-12-09 11:35:54.000 |
54 |
|
2001-12-09 11:36:00.000 |
0 |
|
2001-12-09 11:36:06.000 |
6 |
|
2001-12-09 11:36:12.000 |
12 |
|
2001-12-09 11:36:18.000 |
18 |
|
2001-12-09 11:36:24.000 |
24 |
|
2001-12-09 11:36:30.000 |
30 |
|
2001-12-09 11:36:36.000 |
36 |
|
2001-12-09 11:36:42.000 |
42 |
|
2001-12-09 11:36:48.000 |
48 |
|
2001-12-09 11:36:54.000 |
54 |
|
2001-12-09 11:37:00.000 |
0 |