Cycle count - query 2: using multiple tags
- Last UpdatedFeb 07, 2025
- 1 minute read
SELECT DateTime, TagName, Value
FROM History
WHERE TagName IN ('SysTimeMin','SysTimeSec')
AND DateTime >= '2001-12-09 11:35'
AND DateTime < '2001-12-09 11:36'
AND wwRetrievalMode = 'Cyclic'
AND wwCycleCount = 300
The results are:
|
DateTime |
TagName |
Value |
|
2001-12-09 11:35:00.000 |
SysTimeMin |
35 |
|
2001-12-09 11:35:00.000 |
SysTimeSec |
0 |
|
2001-12-09 11:35:00.200 |
SysTimeMin |
35 |
|
2001-12-09 11:35:00.200 |
SysTimeSec |
0 |
|
2001-12-09 11:35:00.400 |
SysTimeMin |
35 |
|
2001-12-09 11:35:00.400 |
SysTimeSec |
0 |
|
2001-12-09 11:35:00.600 |
SysTimeMin |
35 |
|
2001-12-09 11:35:00.600 |
SysTimeSec |
0 |
|
... |
||
|
2001-12-09 11:35:59.200 |
SysTimeMin |
35 |
|
2001-12-09 11:35:59.200 |
SysTimeSec |
59 |
|
2001-12-09 11:35:59.400 |
SysTimeMin |
35 |
|
2001-12-09 11:35:59.400 |
SysTimeSec |
59 |
|
2001-12-09 11:35:59.600 |
SysTimeMin |
35 |
|
2001-12-09 11:35:59.600 |
SysTimeSec |
59 |
|
2001-12-09 11:35:59.800 |
SysTimeMin |
35 |
|
2001-12-09 11:35:59.800 |
SysTimeSec |
59 |
Notice that the values of the two tags are mixed together in the same column.