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

AVEVA™ BI Gateway

ProductionEvents

  • Last UpdatedJun 09, 2023
  • 2 minute read

This Azure function custom query returns the production events. The custom query expression supports the following parameters:

Parameter Name

Parameter Choice

Example

Description

QueryName

Required

ProductionEvents

Azure function query name

SelectColumn

Required

["*"]

Option to pick required properties from MES

Filter

Required

"endswith (myFilter,'')"

Expression to apply filter on the production events.

StartDateTime

Optional

"[RequestedStartTime]"

Any valid UTC date time value.

To leverage [RequestedStartTime] parameter for populating a time defining dimension, you must enable incremental update feature for the dimension. For more information, see Configure an incremental update for a dimension.

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

Property Name

Datatype

Description

ProducedTime

DateTime

The UTC time when the production was added. The default is the current time.

Equipment

String

The equipment name.

Namespace

String

The equipment namespace.

DispositionReason

String

The disposition reason or automation value for the production that is being added. The reason must exist in the efficiency model.

DispositionType

Int32

A read-only property, which is ignored if passed. It is set internally based on the DispositionReason.

Quantity

Double

The quantity of items that were produced. Quantity can be positive or negative value. A negative quantity results in reducing existing event quantities with the same disposition reason. Negative quantities also result in an Http 204 (No Content) being returned. However, an error is returned if the negative quantity is greater than the produced quantity for the active production run.

OriginalQuantity

Double

A read-only property, which is ignored if passed. If a production event is ever adjusted due to an Edit or Reclassify, this property holds the original value before it was adjusted. Typically for internal use only.

Comment

String

A comment about the production that is being added.

AutomationSource

String

This parameter is for internal use.

Id

String

The ProductionEvent ID.

LastModified

DateTime

The UTC time when the production was modified.

_etag

String

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

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