Operation Details
Description: Returns the count of all matching Product Evidence Form Links for the corresponding Product in the given date range
Sterotype: ns
SQL 
SELECT
  COUNT(*)
INTO
  :value 
FROM
  ProductEvidenceFormLink 
WHERE ProductEvidenceFormLink.productID = :productID 
  AND ProductEvidenceFormLink.evidenceFormID = :evidenceFormID 
  AND 
  (
    ProductEvidenceFormLink.recordStatus = :recordStatus 
    OR :recordStatus IS NULL 
  ) 
  AND 
  (
    ProductEvidenceFormLink.productEvidenceFormLinkID <> :productEvidenceFormLinkID 
    OR :productEvidenceFormLinkIDIsNull <> '0' 
  ) 
  AND 
  (
    
    (
      :startDate >= ProductEvidenceFormLink.startDate 
      AND 
      (
        :startDate <= ProductEvidenceFormLink.endDate 
        OR ProductEvidenceFormLink.endDate IS NULL 
      ) 
    ) 
    OR 
    (
      :startDate <= ProductEvidenceFormLink.startDate 
      AND 
      (
        :endDate >= ProductEvidenceFormLink.startDate 
        OR :endDate IS NULL 
      ) 
    ) 
  )