Operation Details
Description: @Deprecated Since curam 6.0, replaced by { @Link MilestoneDelivery#searchMilestoneConfigurationsByCaseTypeIDAndCaseType() }. See release note:CR00234817 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.type
INTO
  :milestoneConfigurationID,
  :name,
  :type 
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 
  ) 
ORDER BY MilestoneConfiguration.type