system.kanoa.inventory.getPartsUsedByWorkOrderEvents(paramsDict)

Returns parts-consumption history sourced from the [cms].[vwPartsUsedByWorkOrderEvent] view, reporting which parts were used against which work order events. All parameters are optional filters passed in a single dictionary, allowing lookups by work order event, inventory transaction, asset, part, or location; omitting paramsDict keys, or passing an empty dictionary, returns the full unfiltered result set.

---

Parameters

paramsDict Dictionary: Optional filters. Valid keys include workOrderEventId, inventoryTransactionId, assetId, partId, assetPath, assetName, assetTypeName, partNumber, partDescription, locationCode, locationName, binCode, usedBy

---

Returns

data pyDataset

---

Example

paramsDict = {'workOrderEventId': 62}

data = system.kanoa.inventory.getPartsUsedByWorkOrderEvents(paramsDict)
data = system.kanoa.utilities.convertDatasetToJSON(data)

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
costCenterCode None
supplierId None
notes None
partId 3
createdByUser jason
assetTypeName None
referenceType None
transactionTypeCode ISSUE
quantitySign -1
inventoryAssetPath Kanoa Box Co\Warehouse\Parts Room
changedDate None
lastUpdated Wed Jul 01 19:36:58 UTC 2026
costCenterId None
referenceNumber None
assetId None
assetPath None
changedBy None
changedByUser None
inventoryAssetId 2968
partCategoryPath BBB
inventoryAssetTypeName Storage Location
supplierName None
lastUpdatedBy jason
uomCode FT
defaultUomId 2
quantity 30.0
partPath BBB\A1
inventoryAssetName Parts Room
transactionDate Wed Jul 01 19:36:58 UTC 2026
transactionTypeName Issue from inventory
createdDate Wed Jul 01 19:36:58 UTC 2026
createdBy 5
inventoryTransactionId 26
unitCost None
assetName None
costCenterName None
inventoryTransactionTypeId 2
partNumber A1
>>>