system.kanoa.event.getAssetProductionEventsByShift(paramsDict)
Returns production data by shift filtered by the given parameters
Parameters
paramsDict Dictionary
| - assetId | Integer | |
| - assetPath | String | |
| - endDate | DateTime | |
| - modeId | Integer | Optional i.e. 2 production or None for all modes |
| - modeName | String | Optional i.e. 'production' or None for all modes |
| - startDate | DateTime | |
| - workOrderId | Integer | Optional |
Returns
productionData pyDataset
Example
startDate = system.date.parse("2025-11-01 00:00:00")
endDate = system.date.parse("2025-11-05 00:00:00")
data = system.kanoa.event.getAssetProductionEventsByShift({'assetId': 510, 'startDate': startDate, 'endDate': endDate})
data = system.kanoa.utilities.convertDatasetToJSON(data)
for k,v in data[0].items():
print k,v
>>>
endDate 2024-10-23 03:54:11.55
modeTypeId 5
ShiftId 363
wasteCounterId 132799
shiftName 3rd Shift
itemName Wheat Bread Dough
tgtThreshold 0.1
modeEnd None
plannedDowntimeSecs None
period Hour
modeSourceName Operator
infeedRateSecs None
tgtQ 0.8
modeStart 2024-06-21 18:52:03.0
outfeedUnits lbs
modeTypeName Production
quality 1.0
itemId 87
standardRate 60.0
ModeCode 1
wasteUnits lbs
tgtA 0.8
infeedCounterId 132800
tgtP 0.8
workOrderId 43
iconPath kanoa/production
infeedUnits lbs
startDate 2024-10-22 23:00:00.0
modeName Production
itemColor #a291ed
modeEventId 43480
runtimeSecs None
availability None
targetCount None
rawWasteCount None
outfeedCount 283.0
scheduleRate 60.0
durationSecs 17651.0
modeId 2
assetId 510
assetPath Kanoa Industries\Buffalo Bakery\Production\Mix Line 1
infeedCount 283.0
wasteCount 0.0
unplannedDowntimeSecs 17651
userName srussem
outfeedCounterId 132798
userId 35
modeColor #00639a
performance None
rawOutfeedCount 283.0
workOrderName WO-010
rawInfeedCount 283.0
itemClassColor None
packageCount 1.0
tgtOEE 0.6
>>>