Database SQL Operation: BaselinePlanGroup.searchChildPlannedGroupsByBaselineIDAndPlannedGroupID
Description: | lists the expected end dates, expected start date, actual start dates, actual end dates, names, and planned groups id's for all planned groups of the baseline planned group |
Sterotype: | nsmulti |
SELECT
BaselinePlanGroup.plannedGroupID,
BaselinePlanGroup.plannedGroupName,
actualStartDate,
actualEndDate,
expectedStartDate,
expectedEndDate
INTO
:plannedGroupID,
:plannedGroupName,
:actualStartDate,
:actualEndDate,
:expectedStartDate,
:expectedEndDate
FROM
BaselinePlanGroup
WHERE BaselinePlanGroup.parentGroupID = :plannedGroupID
AND BaselinePlanGroup.baselineID = :baselineID
|