Database SQL Operation: PlanTemplateMilestone.searchMilestoneAndIdsByPlanTemplate
| Description: | Returns the list of milestones and the related IDs created at a plan level in the in a service plan template. |
| Sterotype: | nsmulti |
SELECT
PlanTemplateMilestone.planTemplateMilestoneID,
MilestoneConfiguration.nameTextID,
PlanTemplateMilestone.planTemplateID,
PlanTemplateMilestone.planTemplatePlanGroupID,
PlanTemplateMilestone.planTemplateSubGoalID
INTO
:planTemplateMilestoneID,
:nameTextID,
:planTemplateID,
:planTemplatePlanGroupID,
:planTemplateSubGoalID
FROM
PlanTemplateMilestone,
MilestoneConfiguration
WHERE PlanTemplateMilestone.planTemplateID = :planTemplateID
AND PlanTemplateMilestone.planTemplatePlanGroupID is null
AND PlanTemplateMilestone.planTemplateSubGoalID is null
AND PlanTemplateMilestone.milestoneConfigurationID = MilestoneConfiguration.milestoneConfigurationID
ORDER BY PlanTemplateMilestone.LastWritten
|
