CQAnalogSummary
- Last UpdatedJan 11, 2021
- 1 minute read
This Azure custom query returns summary values for analog tags based on the query expression.
Note: This custom query is supported to ensure backward compatibility.
The custom query expression supports the following parameters.
|
Parameter Name |
Parameter Choice |
Example |
Description |
|
QueryName |
Required |
CQAnalogsummary |
Azure function query name |
|
SelectColumn |
Optional |
["*"] Or ["FQN","StartDateTime", "Minimum", "Maximum", "Average", "StdDev", "Integral", "Count"] |
Option to select required properties from AVEVA Insight. |
|
Tag |
Optional |
{ "Filter": "RetrievalMode eq 'Cyclic'", "Select": ["FQN"," RetrievalMode"] } Or { "Filter":"startswith(FQN,'Weather.Los Angeles')" } |
The Tag expression is used to apply a filter on the tags. The Filter parameter is used to apply a filter on the tags. |
|
Select |
Optional |
{ "Filter": "RetrievalMode eq 'Cyclic'", "Select": ["FQN"," RetrievalMode"] } Or { "Filter":"startswith(FQN,'Weather.Los Angeles')" } |
The Select parameter is used to specify the property name that could be used in the tag filter. If extended property is used in the filter, then it is must to specify in the select. |
|
RetrievalMode |
Optional |
cyclic or Full. |
AVEVA Insight query retrieval mode. |
|
Resolution |
Optional |
3000 |
A valid numeric value in milliseconds |
For more information about the supported Filter expressions, see the "Query Expression Operator" section.
Sample query expression
{
"QueryName": "CQAnalogsummary",
"SelectColumn": ["FQN","StartDateTime","Average"],
"Tag": {
"Filter": "startswith(FQN,'Weather.Los Angeles')",
"Select": ["FQN","Average"]
},
"RetrievalMode":"Full",
"Resolution":3000
}