Please ensure Javascript is enabled for purposes of website accessibility
Powered by Zoomin Software. For more details please contactZoomin

AVEVA™ BI Gateway On-Premises

ProcessValues

  • Last UpdatedJan 11, 2021
  • 1 minute read

This Azure function custom query returns the process values for the given tags. The custom query expression supports the following parameters:

Parameter Name

Parameter Choice

Example

Description

QueryName

Required

ProcessValues

Azure function query name

SelectColumn

Optional

["*"]

Or ["FQN", "DateTime", "OpcQuality", "Text", "Value"]

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. The datetime value should be greater than "StartDateTime".

Sample query expression

{

"QueryName": "ProcessValues",

"SelectColumn": ["FQN","DateTime","OpcQuality","Text","Value"],

"FQNS": ["Weather.Los Angeles.Temperature","Weather.Los Angeles.Humidity"],

"StartDateTime" : "[RequestedStartTime]",

"EndDateTime": "[RequestedEndTime]"

}

Related Links
TitleResults for “How to create a CRG?”Also Available in