Database SQL Operation: IssueResolutionApprovalCheck.readByOrgUnitTypeCodeIssueAndStatus
Description: | This method returns the maximum percentage and record count of active approval checks configured for an organization unit and a particular issue. |
Sterotype: | ns |
SELECT
MAX(percentage),
COUNT(*)
INTO
:percentage,
:numRecords
FROM
IssueResolutionApprovalCheck
WHERE organisationUnitID = :organisationUnitID
AND issueConfigurationID = :issueConfigurationID
AND typeCode = :typeCode
AND recordStatus = :recordStatus
|