E3ArchiveInterpolate

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

Was this page useful?