Skip to main content

system.kanoa.quality.sheet.getSheetVersionHistory

Requires kanoaQDS license

Description

Returns check sheet version history from the database with optional filters.

Syntax

getSheetVersionHistory(paramsDict)

Parameters:

– paramsDict (dictionary): Dictionary of filters for the query.

Returns:

– data (pyDataset): Result set of version history rows matching the filters.

Dictionary

ParameterTypeRequiredNotes
masterChkShtIdintNoFilter by master check sheet ID
chkShtIdintNoFilter by specific check sheet ID
chkShtNamestringNoFilter by check sheet name (supports LIKE search)
chkShtVersionStateIdintNoFilter by version state ID
chkShtVersionStateNamestringNoFilter by version state name (supports LIKE search)

Code Examples

# All history for a master
params = {"masterChkShtId": 1001}
dataset = system.kanoa.quality.sheet.getSheetVersionHistory(paramsDict=params)

# History for a specific sheet
params = {"chkShtId": 2002}
dataset = system.kanoa.quality.sheet.getSheetVersionHistory(paramsDict=params)

# Filter by state name (LIKE)
params = {"chkShtVersionStateName": "%Released%"}
dataset = system.kanoa.quality.sheet.getSheetVersionHistory(paramsDict=params)

# Filter by sheet name (LIKE)
params = {"chkShtName": "%Safety%"}
dataset = system.kanoa.quality.sheet.getSheetVersionHistory(paramsDict=params)