| insert | insert | AUTO_ID: outcomePlanActionID
| Standard Operation | |
| read | read | | Standard Operation | |
| modify | modify | OPTIMISTIC_LOCKING: yes
| Standard Operation | |
| searchByOutcomePlan | readmulti | | Returns a list of all actions for the given outcome plan.
| |
| searchByOwnerAndOutcomePlan | readmulti | | Returns a list of all actions for the given owner and outcome plan.
| |
| searchByResponsibilityAndOutcomePlan | readmulti | | Returns a list of all actions for the given responsibility and outcome plan. | |
| searchByNameActionAdminAndDateRange | readmulti | WHERE: status != 'OPAS10004'
AND (
(name = :name AND outcomePlanActionAdminID IS NULL)
OR
(name IS NULL AND outcomePlanActionAdminID = :outcomePlanActionAdminID)
)
AND (
startDate <= :endDate
AND (endDate >= :startDate OR endDate IS NULL)
)
| Returns a list of all actions for the given name, outcome plan action admin and date range. | |
| searchByNameActionAdminAndStartDate | readmulti | WHERE: status != 'OPAS10004'
AND (
(name = :name AND outcomePlanActionAdminID IS NULL)
OR
(name IS NULL AND outcomePlanActionAdminID = :outcomePlanActionAdminID)
)
AND (
startDate >= :startDate
OR endDate IS NULL
)
| Returns a list of all actions for the given name, outcome plan action admin and start date. | |
| searchByResponsibilityRelatedIDAndType | readmulti | | Returns a list of actions for the given responsibility related ID and type. | |
| searchByStatusAndDate | readmulti | WHERE: status = :status
AND
startDate <= :date
AND
(endDate IS NULL OR endDate >= :date)
| Returns a list of actions for the given status where the start date is before the date supplied and there is either no end date or an end date that is after the date supplied. | |
| modifyNotStartedActions | ns | | Updates the status of actions to 'In Progress' where the action status is 'Not Started' and the start date is before the date supplied and there is either no end date or an end date that is after the date supplied. | SQL |
| searchByCaseAndDateRange | readmulti | WHERE: outcomePlanID=:outcomePlanID
AND
(
(startDate >= :startDate AND startDate <= :endDate)
OR
(startDate <= :startDate AND (endDate IS NULL OR endDate >= :startDate))
)
| Returns a list of all actions for the given outcome plan id within the specified date range. | |
| searchByNameActionAdminConcernRoleAndDateRange | readmulti | WHERE: status != 'OPAS10004'
AND (
(name = :name AND outcomePlanActionAdminID IS NULL)
OR
(name IS NULL AND outcomePlanActionAdminID = :outcomePlanActionAdminID)
)
AND (
startDate <= :endDate
AND (endDate >= :startDate OR endDate IS NULL)
)
AND EXISTS (
SELECT outcomePlanActionRoleID
FROM outcomePlanActionRole, caseParticipantRole
WHERE outcomePlanActionRole.outcomePlanActionID = outcomePlanAction.outcomePlanActionID AND outcomePlanActionRole.caseParticipantRoleID = caseParticipantRole.caseParticipantRoleID
AND caseParticipantRole.participantRoleID = :concernRoleID
AND outcomePlanActionRole.recordStatus = 'RST1'
AND caseParticipantRole.recordStatus = 'RST1'
)
| Returns a list of all actions for the given name, outcome plan action admin, concern role and date range. | |
| searchByNameActionAdminConcernRoleAndStartDate | readmulti | WHERE: status != 'OPAS10004'
AND (
(name = :name AND outcomePlanActionAdminID IS NULL)
OR
(name IS NULL AND outcomePlanActionAdminID = :outcomePlanActionAdminID)
)
AND (
startDate >= :startDate
OR endDate IS NULL
)
AND EXISTS (
SELECT outcomePlanActionRoleID
FROM outcomePlanActionRole, caseParticipantRole
WHERE outcomePlanActionRole.outcomePlanActionID = outcomePlanAction.outcomePlanActionID AND outcomePlanActionRole.caseParticipantRoleID = caseParticipantRole.caseParticipantRoleID
AND caseParticipantRole.participantRoleID = :concernRoleID
AND outcomePlanActionRole.recordStatus = 'RST1'
AND caseParticipantRole.recordStatus = 'RST1'
)
| Returns a list of all actions for the given name, outcome plan action admin, concern role and start date. | |
| searchByNameActionConcernroleAndDateRange | nsmulti | | | SQL |
