CQProcessValues
- Last UpdatedJan 11, 2021
- 1 minute read
This Azure custom query returns the process value of the 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 |
CQProcessValues |
Azure function query name |
|
SelectColumn |
Optional |
["*"] Or ["FQN","DateTime", |
Option to pick required properties from AVEVA Insight |
|
Tag |
Optional |
{ "Filter": "startswith(Location,'/Lake')", "Select": ["FQN","Location"] } |
The Tag expression is used to apply a filter on the tags. The Filter parameter is used to apply a filter on the tags. 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. |
|
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". |
|
RetrievalMode |
Optional |
cyclic or Full. |
Retrieval mode of the query |
|
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": "CQProcessValues",
"SelectColumn": ["FQN","DateTime"],
"Tag": {
"Filter": "startswith(Location,'/Lake')",
"Select": ["FQN","Location"]
},
"StartDateTime":"[RequestedStartTime]",
"EndDateTime":"[RequestedEndTime]",
"RetrievalMode":"Full",
"Resolution":3000
}