Database SQL Operation: PlannedGroup.readPlanSGMinAndMaxDatesForPlanGroup
Description: | Reads the min and max dates for all subgoal for who have a specific plan group set as their parent group id. |
Sterotype: | ns |
SELECT
MIN(PlannedSubGoal.actualStartDate),
MAX(PlannedSubGoal.actualEndDate),
MIN(PlannedSubGoal.expectedStartDate),
MAX(PlannedSubGoal.expectedEndDate)
INTO
:actualStartDate,
:actualEndDate,
:expectedStartDate,
:expectedEndDate
FROM
PlannedSubGoal
WHERE PlannedSubGoal.plannedGroupID = :plannedGroupID
|