aaSummaryDetail
- Last UpdatedMar 18, 2021
- 1 minute read
Returns summary details for one or more tags that are associated with a particular summary operation. The type of aggregation for the tag can optionally be included for each tag that you list.
The starting and ending times are used to specify the time at which the calculation started/ended for the operation.
Syntax
aaSummaryDetail TagList, StartTime, EndTime, OrderBy
where:
|
Argument |
Description |
|---|---|
|
TagList |
A list of tags delimited by a comma (,). This value is of data type nvarchar(4000), with no default. |
|
StartTime |
The starting timestamp for the calculation. This value is of data type nvarchar(50), with no default. |
|
EndTime |
The ending timestamp for the calculation. This value is of data type nvarchar(50), with no default. |
|
OrderBy |
The column by which the results will be ordered. By default, the TagName column is used. This value is of data type nvarchar(500). |
Permission
Execute permission defaults to the public group.
Examples
This example returns the average and minimum values for 'ReactTemp' and the maximum value for 'ReactLevel' between 12:12 p.m. and 2:14 p.m. on May 12, 2001. The returned rows are ordered by the date of the summary.
aaSummaryDetail "ReactTemp('AVG','MIN'), ReactLevel('MAX')", "2001-05-12 12:12:00.000", "2001-05-12 12:14:00.000", "SummaryDate"
This example returns all aggregate values for 'ReactTemp' and 'ReactLevel' between 12:12 p.m. and 2:14 p.m. on May 12, 2001.
aaSummaryDetail "ReactTemp, ReactLevel", "2001-05-12 12:12:00.000", "2001-05-12 12:14:00.000"