<< Click to Display Table of Contents >>
E3ArchiveEx |
Returns a stored value relative to an instant, as exposed in the ArchivedValue function. This is only used for Previous (0), Next (2), and ExactTime (3) subtypes. Its formal description is the following:
E3ArchiveEx(
@iSubType int,
@strTableName VARCHAR(100),
@strAliasName VARCHAR(100),
@dDate float,
@strFilter VARCHAR(500),
@bQuality int)
Where:
•@iSubType: Function's subtype. Possible values are 0: Previous, 2: Next, or 3: Exact instant
•@strTableName: Name of a table to query
•@strAliasName: Title for the FieldValue column
•@dDate: Instant in time for the search, in Float format
•@strFilter: Filter options for the value
•@bQuality: If different from 0 (zero), only includes Tags with Good quality
This Stored Procedure returns a single result row with E3TimeStamp, Quality, and FieldValue columns.