<< Click to Display Table of Contents >>
E3ArchiveInterpolate |
Returns points immediately before and after an instant, as exposed in the ArchivedValue function, but only for the Interpolated subtype. Its formal description is the following:
E3ArchiveInterpolate(
@strTableName VARCHAR(100),
@dDate float,
@strFilter VARCHAR(500),
@type int,
@bQuality int)
Where:
•@strTableName: Name of a table to query
•@dDate: Instant in time for the search, in Float format
•@strFilter: 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 a single result row with E3TimeStamp and FieldValue columns.