E3CalculatedData

<< Click to Display Table of Contents >>

 

E3CalculatedData

This is equivalent to the CalculatedData function. Its formal description is the following:

E3CalculatedData(
  @iSubType     int,
  @strTableName VARCHAR(100),
  @iModMin      int,
  @dStartDate   float,
  @dEndDate     float,
  @strWhere     VARCHAR(4000),
  @type         int,
  @bQuality     int)

 

Where:

@iSubType: Calculation subtype. Possible values are 0: Total, 1: Minimum, 2: Maximum, 3: Standard deviation, 4: Range, 5: Average, and 6: Mean

@strTableName: Name of a table to query

@iModMin: Time interval, in seconds, that this Stored Procedure must use to perform aggregations and groupings

@dStartDate: An initial date, in Float format

@dEndDate: An ending date, in Float format

@strWhere: Filter options for the value

@type: Data type. Possible values are 0: String, 1: Bit or Integer, or 2: Analog

@bQuality: If different from 0 (zero), only includes Tags with Good quality

 

This Stored Procedure returns its results with E3TimeStamp and FieldValue columns.

Was this page useful?