<< Click to Display Table of Contents >>
E3CompDataEx |
This is equivalent to the CompressedDataStartEndTime function. Its formal description is the following:
E3CompDataEx(
@strTableName VARCHAR(100),
@dStartDate float,
@dEndDate float,
@strFilter VARCHAR(500),
@strOrder VARCHAR(100),
@bQuality int)
Where:
•@strTableName: Name of a table to query
•@dStartDate: An initial date, in Float format
•@dEndDate: An ending date, in Float format
•@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 values found in the specified interval, with E3TimeStamp, Quality, and FieldValue columns.