system.kanoa.quality.sheet.getSheetVersionStates

Requires kanoaQDS license

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)