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.