E3NCompDataEx

<< Click to Display Table of Contents >>

 

E3NCompDataEx

This is equivalent to the CompressedDataNValues function. Its formal description is the following:

E3NCompDataEx(
  @strTableName VARCHAR(100),
  @dDate        float,
  @iNValues     int,
  @strFilter    VARCHAR(500),
  @strOrder     VARCHAR(100),
  @bQuality     int)

 

Where:

@strTableName: Name of a table to query

@dDate: Instant in time for the search, in Float format

@iNValues: The number of values to return

@strFilter: Filter options for the value

@strOrder: Options to order results by a field different from E3TimeStamp

@bQuality: If different from 0 (zero), only includes Tags with Good quality

 

This Stored Procedure returns all requested values, if found, with E3TimeStamp, Quality, and FieldValue columns.

Was this page useful?