system.kanoa.cmms.getWorkOrderEvents(paramsDict)
Retrieves work order events matching the optional filter criteria supplied in paramsDict.
Each row in the returned dataset represents a single work order event � a specific scheduled or requested occurrence of a work order being executed on an asset, rather than the work order definition itself.
All keys within paramsDict are optional; any key that is omitted is simply not applied as a filter, so calling the function with an empty dictionary returns all work order events.
Parameters
paramsDict Dictionary
| - assetId | Integer | The asset the work order event is on, exactly |
| - assetPath | String | Every asset whose path starts with this (the asset and those under it, and a sibling whose name starts the same, such as Machine 10 for Machine 1). Use assetId for one asset |
| - assignedTo | Integer | |
| - endDate | DateTime | With startDate |
| - isActive | Boolean | |
| - requestedBy | Integer | |
| - scheduleTypeId | Integer | |
| - scheduleTypeName | String | |
| - startDate | DateTime | With endDate: closed work order events due in the window. Active ones are returned whatever their due date (with isActive False, only closed ones due in the window) |
| - title | String | |
| - workOrderEventName | String | |
| - workOrderId | Integer | |
| - workOrderNameTitle | String | filter on both the workOrderName and the title field |
| - workOrderPriorityId | Integer | |
| - workOrderPriorityName | String | |
| - workOrderEventStatusCategoryId | Integer | |
| - workOrderEventStatusCategoryName | String | |
| - workOrderEventStatusId | Integer | |
| - workOrderEventStatusName | String |
Returns
workOrderEventData pyDataset
Example
# An asset's work order events due in the last week, and any still open
paramsDict = {'assetId': 6121, 'startDate': system.date.addDays(system.date.now(), -7), 'endDate': system.date.now()}
events = system.kanoa.cmms.getWorkOrderEvents(paramsDict)
# Get all work order events currently 'In Progress'
paramsDict = {"workOrderStatusName": "In Progress"}
data = system.kanoa.utilities.convertDatasetToJSON(system.kanoa.cmms.getWorkOrderEvents(paramsDict))
for i, row in enumerate(data):
print 'Row %i'%i
for k,v in row.items():
print k,v
break #Just limiting to returning the columns from the first record for display purposes
>>>
Row 0
workOrderEventStatusName Completed
workOrderEventStatusId 6
workOrderEventName MWO00047
workOrderPriorityName Low
scheduleTypeName One Time
workOrderPriorityIconPath None
dueDate Sat Mar 14 14:00:01 UTC 2026
description
conditionName None
isActive False
title jjj
workOrderEventStatusCategoryId 4
enabled True
assignedTo None
changedDate Tue Mar 17 01:53:29 UTC 2026
workOrderEventStatusColor #CCFFCC
workOrderPriorityColor --kcGray-10
maintenanceSubTypeId None
conditionId None
assetId None
assetPath None
changedBy 5
procedureName None
maintenanceSubTypeName None
workOrderEventId 4
assignedUser None
scheduleTypeId 1
maintenanceTypeId 1
conditionInfo None
lastGeneratedDate None
workOrderEventStatusCategoryName Closed
procedureId None
requestedBy 5
createdDate Sat Mar 14 14:01:55 UTC 2026
workOrderPriorityId 1
createdBy 5
lastGeneratedValue None
maintenanceTypeColor --kcBlue-20
assetName None
workOrderId 67
occurrenceKey None
requestedByUser jason
maintenanceTypeName Corrective
workOrderConditionId None
>>>