SQL:ConcernRoleAttachmentLink.countByAttachmentIDAndRecordStatus

Database SQL Operation: ConcernRoleAttachmentLink.countByAttachmentIDAndRecordStatus

Operation Details

Description:	Counts the number of records relating to the specified attachment ID and record status.
Sterotype:	ns

SQL

SELECT
  COUNT (*)
INTO
  :numberOfRecords
FROM
  ConcernRoleAttachmentLink
WHERE AttachmentID = :attachmentID 
AND 
StatusCode = :recordStatus