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

AVEVA™ Historian

aaEventDetection

  • Last UpdatedMar 10, 2025
  • 2 minute read

Detects the number of events in history in which the data value for the specified tag matched the criteria defined by the remaining arguments. This stored procedure is used by the event subsystem and should not be modified.

Syntax

aaEventDetection TagName, Operator, DetectValue, Edge, Resolution, StartTime, EndTime

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.

Operator

The comparison operator. Valid values are:

  • >

  • >=

  • <

  • <=

  • =

  • <>

    This value is of data type char(2), with no default.

DetectValue

The value against which the stored values for the tag are compared to determine if the event occurred. This value is of data type float(25), with a default of none.

Edge

The type of edge detection result set that the query will return. Valid values are:

  • NONE

  • LEADING

  • TRAILING

  • BOTH

    This value is of data type char(8), 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.

StartTime

The starting timestamp for the data to query. This value is of dataype varchar(30), with no default.

EndTime

The ending timestamp for the data to query. This value is of dataype varchar(30), with no default.

Remarks

You can apply a resolution only if you set the value of the Edge argument to NONE.

Permission

Execute permission defaults to the aaAdministrators group.

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