system.kanoa.quality.sheet.getSheetVersionStates
Description
Returns check sheet version states from the database.Syntax
getSheetVersionStates(paramsDict)Parameters:
– paramsDict (dictionary): Dictionary of filters for query.
Returns:
– data (pyDataset): Result set of matching check sheet version states.
Dictionary
Parameter | Type | Required | Notes |
---|---|---|---|
enabled | bool | No | Filter by enabled state |
chkShtVersionStateId | int | No | Filter by version state ID |
chkShtVersionStateName | string | No | Filter by version state name (supports LIKE search) |
Code Examples
# Get all enabled sheet version states
params = {"enabled": True}
dataset = system.kanoa.quality.sheet.getSheetVersionStates(paramsDict=params)
for row in dataset:
print(row["chkShtVersionStateId"], row["chkShtVersionStateName"])
# Get version state by ID
params = {"chkShtVersionStateId": 2}
dataset = system.kanoa.quality.sheet.getSheetVersionStates(paramsDict=params)
# Get version state by name
params = {"chkShtVersionStateName": "%Active%"}
dataset = system.kanoa.quality.sheet.getSheetVersionStates(paramsDict=params)