Database SQL Operation: PerformanceMeasureLink.readIncidentsCountForProvider
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
WHERE IncidentParticipantRole.concernRoleID = :resourceID
AND IncidentParticipantRole.recordStatus = :recordStatus
AND IncidentParticipantRole.incidentID = Incident.incidentID
AND Incident.status IN ( :incidentStatus)
|