E3RawData

<< Click to Display Table of Contents >>

 

E3RawData

Returns values from a table without aggregations. Its formal description is the following:

E3RawData(
  @strTable   NVARCHAR(100),
  @dStartDate float,
  @dEndDate   float,
  @strFilter  NVARCHAR(4000),
  @strOrder   NVARCHAR(100))

 

Where:

@strTable: 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

 

This Stored Procedure returns its results with E3TimeStamp, Quality, and FieldValue columns.

 

NOTE

This Stored Procedure is not available as an option in the Functions item on the Fields tab of the Query associated to the Storage.

Was this page useful?