system.kanoa.cmms.getMaintenanceBacklogAging(startDate, assetPath, maintenanceTypeName)

Returns the open maintenance work order backlog, bucketed by how long each item has been sitting open (backlog aging), as of a given start date. Results can optionally be narrowed to a single asset (via assetPath) and/or a single maintenance type, or left unfiltered to aggregate across all assets/types. This is typically used to populate a backlog-aging chart or table on a maintenance dashboard, helping supervisors spot work orders that have gone unaddressed the longest.

---

Parameters

startDate DateTime
assetPath String: Can be None for all
maintenanceTypeName String: Can be None for all

---

Returns

backlogAging pyDataset

---

Example

# Show open backlog aging for the last 90 days, across all assets and maintenance types
startDate = system.date.addDays(system.date.now(), -90)
assetPath = None
maintenanceTypeName = None
data = system.kanoa.utilities.convertDatasetToJSON(system.kanoa.cmms.getMaintenanceBacklogAging(startDate, assetPath, maintenanceTypeName))

for i, row in enumerate(data):
	print 'Row %i'%i
	for k,v in row.items():
		print k,v
	
	break
>>> 
Row 0
workOrderEventName MWO00047
workOrderPriorityName Low
dueDate 2026-03-14 14:00:01.848
title jjj
ageBucket 31-60
createdDate 2026-03-14 14:01:55.163
assetId None
assetName None
ageDays 46
workOrderEventId 4
maintenanceTypeName Corrective
>>>