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