Database SQL Operation: EvidenceApprovalCheck.readByStatusTypeProductID
Description: | Returns the maximum percentage for the specified status, type and product identifier. |
Sterotype: | ns |
SELECT
DISTINCT (percentage)
FROM
EvidenceApprovalCheck
WHERE typeCode = :typeCode
AND productID = :productID
AND recordStatus = :recordStatus
AND percentage =
(
SELECT
MAX(percentage)
INTO
:percentage
FROM
EvidenceApprovalCheck
WHERE typeCode = :typeCode
AND productID = :productID
AND recordStatus = :recordStatus
)
|