Returns data in a format defined by the aggregation Stored Procedure defined in the aggregateFunction parameter.

EpmQueryAggregateData(
  @timeZoneOffset    float,
  @startTime         datetime,
  @endTime           datetime,
  @sampleInterval    bigint,
  @aggregateFunction nvarchar(30),
  @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

•sampleInterval: Time interval used to calculate the aggregation, informed in milliseconds

•aggregateFunction: Name of the aggregation function to use. Valid values for this parameter are Trend, Interpolative, Average, Total, Count, Minimum, Maximum, MinimumActualTime, MaximumActualTime, Range, Delta, TimeAverage, TotalizeAverage, AnnotationCount, DurationINState0, DurationINState1, NumberOfTransitions, Start, End, DurationGood, DurationBad, PercentGood, PercentBad, and WorstQuality. A more detailed description of these functions can be checked on topic Creating a Dataset on Manual do Usuário do Elipse Plant Manager

•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 EpmQueryAggregateData -2,
  '01/15/2013 12:00:00', '01/31/2013 12:00:00',
  1000, 'Interpolative', ' OpcTag04,OpcTag05'

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