Operation Details |
Description: | Returns the minimum actual start and expected start date and the max actual and expected end date for all sub goals of this planned group. |
Sterotype: | ns |
SQL |
SELECT MIN(actualStartDate), MAX(actualEndDate), MIN(expectedStartDate), MAX(expectedEndDate) INTO :actualStartDate, :actualEndDate, :expectedStartDate, :expectedEndDate FROM PlannedSubGoal WHERE PlannedSubGoal.plannedGroupID = :plannedGroupID |