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

AVEVA™ BI Gateway

EquipmentStates

  • Last UpdatedJun 09, 2023
  • 1 minute read

This Azure function custom query returns all the equipment states present in AVEVA Insight. The custom query expression supports the following parameters:

Parameter Name

Parameter Choice

Example

Description

QueryName

Required

EquipmentStates

Azure function query name

SelectColumn

Optional

["*"]

Or

["Name", "Description", "Color", "StateType", "DisableDate", "Id", "_etag"]

Option to pick required properties from AVEVA Insight

The following properties are returned from the Azure function query for "EquipmentStates".

Property Name

Datatype

Description

Name

String

An equipment state name. This is unique across all equipment states.

Description

String

An equipment state description.

Color

String

Represents an equipment state color in the RGB format (#DC0A0A).

StateType

Number

Represents an equipment state type (1=Idle, 2=Runtime, 3=Downtime).

DisableDate

DateTime

The disabled date. If this has a value, then the state is considered deleted.

Id

String

The EquipmentState ID.

_etag

String

This an optimistic concurrency tag which prevents overlapping updates to an entity.

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