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

AVEVA™ Historian

aaSummaryOperationInsert

  • Last UpdatedMar 18, 2021
  • 1 minute read

Inserts a summary operation that will be associated with the specified event tag.

Syntax

aaSummaryOperationInsert TagName, CalcType, Duration, Resolution, TimeStamp, Description

where:

Argument

Description

TagName

The unique name of the tag within the AVEVA Historian system.This value is of data type nvarchar(256), with no default.

CalcType

The type of calculation to be performed: SUM, MAX, MIN, or AVG. This value is of dataype char(3), with no default.

Duration

The period, in seconds, for which the calculation is performed. This value is of data type real, with no default.

Resolution

The sampling rate, in milliseconds, for retrieving the data in cyclic mode. The system returns values stored over the requested time period at the interval specified by the resolution. For example, if you specify a 5000 ms resolution, the system queries for all data during the time period and then only returns those values that occur at each 5000 ms interval, starting with the start date and ending with the end date. This value is of data type int, with no default.

TimeStamp

The timestamp to use when storing the result of the calculation. The timestamp can be either the time when the calculation period starts or ends.

0 = Beginning of the calculation period

1 = End of the calculation period

This value is of data type tinyint, with no default.

Description

The description of the summary operation. This value is of data type nvarchar(50), with a default of NULL.

Permission

Execute permission defaults to the aaAdministrators group.

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