Database SQL Operation: MilestoneDelivery.searchMilestoneConfigsByCaseTypeIDAndCaseType
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 |
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
|