Skip to main content

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

ParameterTypeRequiredNotes
enabledboolNoFilter by enabled state
chkShtVersionStateIdintNoFilter by version state ID
chkShtVersionStateNamestringNoFilter 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)