Operation Details
Description: @Deprecated Since curam 6.0 replaced with {@link MilestoneConfiguration#countMilestoneDuplicatePeriodForModify()} as part of implementing localization of MilestoneConfiguration attributes . See release note: CR00233651. This method checks for overlapping periods with other records with the same issue name. The current record is excluded from the check.
Sterotype: ns
SQL 
SELECT
  COUNT(*)
INTO
  :numberOfRecords 
FROM
  MilestoneConfiguration MC
WHERE 
  name = :name 
  AND recordStatus = :recordStatus 
  AND milestoneConfigurationID <> :milestoneConfigurationID 
  AND 
  (
    
    (
      endDate IS NULL 
      AND 
      (
        :startDate >= startDate 
      ) 
    ) 
    OR 
    (
      :startDate >= startDate 
      AND :startDate <= endDate 
    ) 
    OR 
    (
      :endDate >= startDate 
      AND :endDate <= endDate 
    ) 
    OR 
    (
      :endDate IS NULL 
      AND :startDate <= endDate 
    ) 
    OR 
    (
      :endDate >= startDate 
      AND endDate IS NULL 
    ) 
  )