system.kanoa.quality.sheet.getSheetVersionHistory
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
Parameter | Type | Required | Notes |
---|---|---|---|
masterChkShtId | int | No | Filter by master check sheet ID |
chkShtId | int | No | Filter by specific check sheet ID |
chkShtName | string | No | Filter by check sheet name (supports LIKE search) |
chkShtVersionStateId | int | No | Filter by version state ID |
chkShtVersionStateName | string | No | Filter 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)