system.kanoa.cmms.getWorkOrders(paramsDict)
Queries the CMMS work order table and returns the matching records as a dataset.
Call this function whenever you need to list, filter, or search work orders for a report, dashboard, or screen binding �
for example pulling every open work order for a given asset, or every work order assigned to a specific technician.
All keys in the paramsDict argument are optional, so calling getWorkOrders({}) returns every work order in the system;
supplying one or more keys narrows the result set to records matching all of the supplied filters (an implicit AND across keys).
Parameters
paramsDict Dictionary
| - assetPath | String | |
| - assignedTo | Integer | |
| - enabled | Boolean | |
| - endDate | DateTime | |
| - procedureId | Integer | |
| - requestedBy | Integer | |
| - scheduleTypeId | Integer | |
| - scheduleTypeIdList | List of Integers | |
| - scheduleTypeName | String | |
| - startDate | DateTime | |
| - title | String | |
| - workOrderId | Integer | |
| - workOrderPriorityId | Integer | |
| - workOrderPriorityName | String | |
| - workOrderStatusId | Integer | |
| - workOrderStatusName | String |
Returns
workOrderData pyDataset
Example
# Pull all released, high-priority work orders for Box Line 1.
paramsDict = {
"assetPath": "Kanoa Box Co\Box Plant\Packaging\Box Line 1",
"workOrderStatusName": "Released",
"workOrderPriorityName": "High"
}
data = system.kanoa.utilities.convertDatasetToJSON(system.kanoa.cmms.getWorkOrders(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
workOrderStatusName Released
generateAheadDays None
workOrderPriorityName High
scheduleTypeName One Time
workOrderPriorityIconPath material/report_problem
description Need to make sure they are spick and span
title Clean all corridors
enabled True
assignedTo 5
changedDate Wed Mar 11 15:18:01 UTC 2026
workOrderPath Corrective\Clean all corridors
workOrderPriorityColor --kcOrange-50
maintenanceSubTypeId None
assetPath Kanoa Box Co\Box Plant\Packaging\Box Line 1
assetId 901
changedBy 5
procedureName None
maintenanceSubTypeName None
assignedUser jason
scheduleTypeId 1
maintenanceTypeId 1
lastGeneratedDate None
workOrderScheduleId None
workOrderStatusColor --kcGreen-50
procedureId None
workOrderStatusId 3
requestedBy 5
createdDate Sat Feb 14 00:00:00 UTC 2026
workOrderPriorityId 3
createdBy 5
maintenanceTypeColor --kcBlue-20
rruleStr None
assetName Box Line 1
workOrderId 12
leadTimeDays 5
requestedByUser jason
startDate None
maintenanceTypeName Corrective
>>>