Please ensure Javascript is enabled for purposes of website accessibility
Powered by Zoomin Software. For more details please contactZoomin

AVEVA™ Historian

Use wwResolution, wwCyclecount, and wwRetrievalmode in the same query

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.

Related Links
TitleResults for “How to create a CRG?”Also Available in