Operation Details |
Description: | Returns plannedGroupID, parentGroupID, planned group name, start date, and end date of all existing groups of the specified planned group. |
Sterotype: | nsmulti |
SQL |
SELECT PlannedGroup.plannedGroupID, PlannedGroup.parentGroupID, PlannedGroup.name, PlannedGroup.expectedStartDate, PlannedGroup.expectedEndDate, PlannedGroup.actualStartDate, PlannedGroup.actualEndDate INTO :plannedGroupID, :parentGroupID, :plannedGroupName, :expectedStartDate, :expectedEndDate, :actualStartDate, :actualEndDate FROM PlannedGroup WHERE PlannedGroup.parentGroupID = :plannedGroupID |