SQL:DeterminationConfig.countByDeterminationConfigIDReferenceAndRecordStatus

Database SQL Operation: DeterminationConfig.countByDeterminationConfigIDReferenceAndRecordStatus

Operation Details

Description:	This method is used to count the number of records available with the given combination of DeterminationConfigID, Reference and RecordStatus
Sterotype:	ns

SQL

SELECT
  COUNT (*)
INTO
  :numberOfRecords 
FROM
  DeterminationConfig 
WHERE UPPER(determinationalReference) = :reference 
  AND recordStatus = :recordStatus 
  AND determinationConfigID <> :determinationConfigID