Operation Details
Description: Searches all the wait list entries which has review date within the given date range for a given status.
Sterotype: nsmulti
SQL 
SELECT
  WaitListEntry.waitListEntryID,
  WaitListEntry.waitListID,
  WaitListEntry.caseParticipantRoleID,
  WaitListEntry.position,
  WaitListEntry.priority,
  WaitListEntry.expiryDate,
  WaitListEntry.removalReason,
  WaitListEntry.status,
  WaitListEntry.versionNo,
  WaitListEntry.reviewDate,
  WaitListEntry.comments
INTO
  :waitListEntryID,
  :waitListID,
  :caseParticipantRoleID,
  :position,
  :priority,
  :expiryDate,
  :removalReason,
  :status,
  :versionNo,
  :reviewDate,
  :comments 
FROM
  WaitListEntry 
WHERE WaitListEntry.status = :status 
  AND WaitListEntry.reviewDate >= :startReviewDate
  AND WaitListEntry.reviewDate <= :endReviewDate