Skip to main content

system.kanoa.cmms.getMaintenanceWorkflowChurn(paramsDict)

Returns work orders with workflow churn / reopen-like behavior

Parameters​

paramsDict Dictionary

- endDateDateTimeEnd date
- startDateDateTimeStart date

Returns​

workflowChurn pyDataset

Example​

# Surface work orders with high workflow churn over the last 180 days
paramsDict = {
				'startDate': system.date.addDays(system.date.now(), -90),
				'endDate': system.date.now()
			}
data = system.kanoa.utilities.convertDatasetToJSON(system.kanoa.cmms.getMaintenanceWorkflowChurn(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 Assigned
cancelledTransitionCount 1
workOrderEventName MWO00110
title Bake a Cake
onHoldTransitionCount 3
createdDate 2026-04-08 19:44:42.7
hasWorkflowChurn 1
assetId None
inProgressTransitionCount 5
openTransitionCount 5
assignedTransitionCount 6
assetName None
completedTransitionCount 2
workOrderEventId 62
assignedUser darren
maintenanceTypeName Project
>>>