AnalogSummary
- Last UpdatedJan 11, 2021
- 1 minute read
This Azure custom query returns summary values for analog tags based on search criteria. The custom query expression supports the following parameters.
|
Parameter Name |
Parameter Choice |
Example |
Description |
|
QueryName |
Required |
Analogsummary |
Azure function query name |
|
SelectColumn |
Optional |
["*"] Or ["FQN","StartDateTime", "Minimum", "Maximum", "Average", "StdDev", "Integral", "Count"] |
Option to pick required properties from AVEVA Insight |
|
FQNS |
Required |
["Weather.Los Angeles.Temperature","Weather.Los Angeles.Humidity"] |
Valid Fully qualified name(s). |
|
StartDateTime |
Optional |
"2018-01-01T01:00:00.000000Z" or "[RequestedStartTime]" |
Any valid UTC date time value. |
|
EndDateTime |
Optional |
"2018-01-31T01:00:00.000000Z" or "[RequestedEndTime]" |
Any valid UTC date time value. This datetime value should be greater than "StartDateTime". |
Sample query expression
{
"QueryName": "AnalogSummary",
"SelectColumn": ["FQN","StartDateTime","OpcQuality","Minimum","Maximum","Average","StdDev","Integral","Count"],
"FQNS": ["Weather.Los Angeles.Temperature","Weather.Los Angeles.Humidity"],
"StartDateTime": "[RequestedStartTime]",
"EndDateTime": "[RequestedEndTime]"
}