Operation Details
Description: This method lists milestones which have been configured in administration for the selected case. Only milestones which have no end date or an end date in the future are displayed for selection.
Sterotype: nsmulti
SQL 
SELECT
  MilestoneConfiguration.milestoneConfigurationID,
  MilestoneConfiguration.name,
  MilestoneConfiguration.nameTextID,
  MilestoneConfiguration.type,
  MilestoneConfiguration.typeTextID
INTO
  :milestoneConfigurationID,
  :name,
  :nameTextID,
  :type,
  :typeTextID 
FROM
  MilestoneConfiguration,
  MilestoneLink
WHERE MilestoneLink.caseType = :caseType 
  AND MilestoneLink.caseTypeID = :caseTypeID 
  AND MilestoneLink.milestoneConfigurationID = MilestoneConfiguration.milestoneConfigurationID 
  AND 
  (
    MilestoneConfiguration.endDate is null 
    OR MilestoneConfiguration.endDate >= :endDate 
  )