Executes a query on one or more variables, searching raw data stored in the informed period.

EpmQueryByDate(
  @timeZoneOffset float,
  @startTime      datetime,
  @endTime        datetime,
  @valuesPerNode  int,
  @returnBound    bit,
  @nodelist       nvarchar(max))

Where:

•timeZoneOffset: Timezone to consider. This value is a floating-point number ranging from -12 to 14

•startTime: Query's starting date. The date format depends on the database configuration

•endTime: Query's ending date

•valuesPerNode: Maximum number of records returned by this query. The value 0 (zero) in this parameter indicates that all query records must be returned

•returnBound: Indicates whether this query must return the value stored immediately before and after the informed interval

•nodeList: List with names of Data Objects to query. Users can also inform references and full paths on the Contextual Model, if they were contextualized

Usage example:

EXECUTE EpmQueryRawData 1, -2,
  '01/15/2013 12:00:00', '01/31/2013 12:00:00',
  0, 0, 'OpcTag04,OpcTag05'

In this case, the query returns all values from Basic Variables OpcTag04 and OpcTag05 from the second half of January.