Skip to main content

qds.spDeleteChkItem

Description

Deletes a checklist item (chkItemId) and all its associated events and attribute links. It also nullifies any checklist item triggers that point to it.

Parameters

  • @chkItemId (int): ID of the checklist item to delete.

Key Operations

  • Deletes from chkItemEvent, chkItemAttrLink, and chkItem.
  • Updates chkItemTriggerId to null if referencing this item.

Return Value

Total number of deleted rows.

Code Example​

-- Example: Delete a checklist item with ID 123
EXEC qds.spDeleteChkItem @chkItemId = 123;