<< 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.