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. |