system.kanoa.lot.getRouteSteps
Description
Retrieves route step records filtered by the specified parameters.Syntax
getRouteSteps(paramsDict)Parameters:
– paramsDict (dictionary): Dictionary containing route step filters.
Returns:
– routeStepData (pyDataset): Dataset containing route step records that match the provided filters.
Behavior
The function queries mes.vwRouteStep to return step-level information associated with one or more routes.– Supports filtering by route, operation, step number, and enablement status.
– Returns all related metadata such as item associations, operation details, and audit fields.
– Results are ordered by routeId and stepNum.
Dictionary
Parameter | Type | Required | Notes |
---|---|---|---|
routeId | int | No | Filter by route ID |
routeName | string | No | Filter by route name (supports LIKE search) |
routeStepId | int | No | Filter by route step ID |
lotOperationId | int | No | Filter by associated lot operation ID |
lotOperationName | string | No | Filter by lot operation name (supports LIKE search) |
stepNum | int | No | Filter by step number within the route |
enabled | bool | No | Filter by enabled state of the step |
itemId | int | No | Filter by associated item ID |
itemName | string | No | Filter by associated item name (supports LIKE search) |
Code Examples
# Get all steps for a specific route
paramsDict = {"routeId": 101}
routeStepData = system.kanoa.lot.getRouteSteps(paramsDict=paramsDict)
# Get enabled steps for a specific operation
paramsDict = {"lotOperationName": "%Assembly%", "enabled": True}
routeStepData = system.kanoa.lot.getRouteSteps(paramsDict=paramsDict)
# Get route steps by item name
paramsDict = {"itemName": "%Widget%"}
routeStepData = system.kanoa.lot.getRouteSteps(paramsDict=paramsDict)
# Get a specific step by ID
paramsDict = {"routeStepId": 5001}
routeStepData = system.kanoa.lot.getRouteSteps(paramsDict=paramsDict)