qds.fnGetChkItemStateCount

Description

Returns how many times a specific state was recorded for a checklist event.

Syntax

qds.fnGetChkItemStateCount(@chkShtEventId, @chkStateId)

Parameters:

@chkShtEventId (int): Checklist sheet event Id

@chkStateId (int): Checklist item state Id

Returns:

int: Count of matching checklist item states

Code Example

SELECT qds.fnGetChkItemStateCount(
  2048, 
  3
) AS item_state_count;