Database SQL Operation: ContractPerformanceMeasure.countIncidentsCountForProvider
Description: | Reads the performance measure against incidents for the provider.
@deprecated since 7.0.0.0, This functionality forms part of a feature that is no longer relevant to the product strategy and will not be replaced. |
Sterotype: | ns |
SELECT
COUNT(Incident.incidentID)
INTO
:count
FROM
Incident,
IncidentParticipantRole,
ContractVersion
WHERE ContractVersion.contractVersionID = :resourceID
AND IncidentParticipantRole.concernRoleID = ContractVersion.concernRoleID
AND IncidentParticipantRole.recordStatus = :recordStatus
AND IncidentParticipantRole.incidentID = Incident.incidentID
AND Incident.status IN ( :incidentStatus)
AND Incident.recordedDate BETWEEN ContractVersion.startDate AND ContractVersion.endDate
|