Skip to main content

system.kanoa.lot.linkLotOperationsAssets

Requires kanoaOPS license

Description

Links a list of assets with a list of lot operations. If a link already exists, it is re-enabled; otherwise, a new link record is created.

Syntax

linkLotOperationsAssets(assetIdList, lotOperationIdList, userId)

Parameters:

– assetIdList (list[int]): List of asset IDs to link.
– lotOperationIdList (list[int]): List of lot operation IDs to link.
– userId (int): User performing the linking operation.

Returns:

– recordsModified (int): Number of links created or re-enabled.
– message (string or None): None if success; error details on failure.

Behavior

The function iterates through all combinations of the provided asset and lot operation IDs:

– If a link already exists in mes.lotOperationAssetLink, the link is re-enabled and updated with the user and timestamp.
– If no link exists, a new record is inserted with the enabled flag set to True.
– Returns the total number of links created or updated.

Parameters

ParameterTypeRequiredNotes
assetIdListlist[int]YesList of asset IDs to link to lot operations
lotOperationIdListlist[int]YesList of lot operation IDs to link to assets
userIdintYesUser performing the link operation

Code Examples

# Link multiple assets to multiple operations
assetIdList = [101, 102, 103]
lotOperationIdList = [5, 6]
recordsModified, msg = system.kanoa.lot.linkLotOperationsAssets(
assetIdList=assetIdList,
lotOperationIdList=lotOperationIdList,
userId=123
)
print(recordsModified, msg)

# Link a single asset to a single operation
assetIdList = [42]
lotOperationIdList = [9]
recordsModified, msg = system.kanoa.lot.linkLotOperationsAssets(assetIdList, lotOperationIdList, 123)
print(recordsModified, msg)