Use wwResolution, wwCyclecount, and wwRetrievalmode in the same query
- Last UpdatedMar 20, 2025
- 2 minute read
The results of a database query will vary depending on the combination of resolution, cycle count, and retrieval mode that you use in the query. These results are summarized in the following table (where N is a numeric value). Note that wwResolution is not supported with DAILY retrieval mode; that mode's resolution is always a full day.
|
Retrieval Mode |
Resolution |
Cycle Count |
Results |
|---|---|---|---|
|
CYCLIC |
N |
0 (or no value) |
All stored data for tags during the specified time interval are queried, and then a resolution of N ms applied. |
|
CYCLIC |
0 (or no value) |
0 |
The server will return 100,000 rows per tag specified. |
|
CYCLIC |
0 (or no value) |
N |
All stored data for tags during the specified time interval are queried, and then a cycle count of N evenly spaced rows is applied. |
|
CYCLIC |
N |
(any value is ignored) |
All stored data for tags during the specified time interval are queried, and then a resolution of N ms applied. |
|
CYCLIC |
(no value) |
(no value or a value less than 0) |
The server will return 100 rows per tag specified. |
|
DAILY |
n/a |
0 |
The server will return 0 rows per tag specified. |
|
DAILY |
n/a |
N |
The server will return N rows per tag specified. |
|
DAILY |
n/a |
(no value or a value less than 0) |
The server will return rows from the StartDateTime to present for each tag specified. |
|
DELTA |
(any value is ignored) |
0 |
All values that changed during the specified time interval are returned (up to 100,000 rows total). |
|
DELTA |
(any value is ignored) |
N |
Values that changed during the specified time interval are queried, and then a cycle count (first N rows) is applied. The cycle count limits the maximum number of rows returned, regardless of how many tags were queried. For example, a query that applies a cycle count of 20 to four tags will return a maximum of 20 rows of data. An initial row will be returned for each tag, and the remaining 16 rows will be based on subsequent value changes for any tag. |
|
DELTA |
(any value is ignored) |
(no value) |
All values that changed during the specified time interval are returned (no row limit). |
In general, if there is an error in the virtual columns, or an unresolvable conflict, then zero rows are returned.