Database SQL Operation: CaseNomineeProdDelPattern.searchByDateRange
Description: | Searches for all Case Nominee Product Delivery Pattern records that overlap within the date range. |
Sterotype: | nsmulti |
SELECT
CaseNomineeProdDelPattern.caseNomineeProdDelPatternID,
CaseNomineeProdDelPattern.fromDate,
CaseNomineeProdDelPattern.toDate,
CaseNomineeProdDelPattern.productDeliveryPatternID,
CaseNomineeProdDelPattern.caseNomineeID,
CaseNomineeProdDelPattern.statusCode
INTO
:caseNomineeProdDelPatternID,
:fromDate,
:toDate,
:productDeliveryPatternID,
:caseNomineeID,
:statusCode
FROM
CaseNomineeProdDelPattern
WHERE CaseNomineeProdDelPattern.caseNomineeID = :caseNomineeID
AND
(
(
CaseNomineeProdDelPattern.fromDate <= :toDate
AND
(
CaseNomineeProdDelPattern.toDate >= :fromDate
OR CaseNomineeProdDelPattern.toDate IS NULL
)
)
OR
(
:toDate IS NULL
AND
(
CaseNomineeProdDelPattern.toDate >= :fromDate
OR CaseNomineeProdDelPattern.toDate IS NULL
)
)
)
ORDER BY toDate ASC
|