Skip to main content

system.kanoa.lot.getLotEvents

Description

Retrieves lot events filtered by the provided parameters. Input parameters are inclusive, e.g. an end date is 1/1 at 12:00PM will be included in the results.

Syntax

getLotEvents(paramsDict)
  • Parameters
      paramsDict (dict)
      - lotEventId (int)
      - lotId (int)
      - lotName (string)
      - itemId (int)
      - itemPath (string)
      - enabled (int)
      - lotOperationEventId (int)
      - lotOperationId (int)
      - lotOperationName (string)
      - assetId (int)
      - assetPath (string)
      - itemSourceId (int)
      - itemSourceName (string)
      - lotStateId (int)
      - lotStateName (string)
      - lotStateReasonId (int)
      - lotStateReasonName (string)
      - startDate (datetime)
      - endDate (datetime)
      - workOrderId (int)
      - workOrderName (string)
      - assetTransportName (string)
      - assetTransportPath (string)
      - assetGroupName (string)
      - assetTypeName (string)
      - operationAssetPath (string)
      - operationAssetGroupName (string)
      - operationAssetName (string)
  • Returns
      pyDataset - Lot events dataset.

    • Code Examples​


    paramsDict  = {'lotEventId': 13}
    lotEvents = system.kanoa.lot.getLotEvents(paramsDict)
    lotEventInfo = system.kanoa.utilities.convertDatasetRowToJSON(lotEvents, 0)
    for k,v in lotEventInfo.items():
        print '%s: %s'%(k,v)
    >>>
    lotOperationName: Receive
    itemSourceId: 2
    itemColor: #000000
    createdByUser: jason
    lotStateReasonId: None
    assetTypeName: area
    lotOperationColor: #8AFFFF
    operationAssetId: 509
    shiftName: None
    changedDate: Wed Oct 23 23:03:21 UTC 2024
    operationAssetName: Warehouse
    itemName: itemA
    operationtStamp: Sun Sep 22 21:12:34 UTC 2024
    lotOperationId: 7
    assetId: 509
    assetPath: Kanoa Industries\Buffalo Bakery\Warehouse
    lotStateName: OK
    tStamp: Sun Sep 22 21:12:34 UTC 2024
    changedBy: 5
    lotEventId: 13
    changedByUser: jason
    itemDescription: 
    lotStateReasonName: None
    shiftId: None
    itemUnitName: lbs
    itemSourceName: output
    assetTransportName: None
    assetGroupName: None
    assetTransportId: None
    operationAssetPath: Kanoa Industries\Buffalo Bakery\Warehouse
    lotId: 241
    lotName: AAA
    lotEventQty: 1198.7
    lotStateId: 1
    itemId: 70
    itemClassPath: RM
    createdDate: Sun Sep 22 21:11:41 UTC 2024
    itemPath: RM\itemA
    createdBy: 5
    workOrderName: 
    itemUnitId: 7
    assetName: Warehouse
    comment: 
    workOrderId: 42
    assetTransportPath: None
    lotOperationEventId: 141
    >>>