Operation Details
Description: Searches for a Wait List Entry by Resource ID, Case Participant Role ID and Wait List Entry 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
  WaitList,
  WaitListEntry 
WHERE WaitList.waitListID = WaitListEntry.waitListID 
  AND WaitList.resourceID = :resourceID 
  AND WaitListEntry.caseParticipantRoleID = :caseParticipantRoleID 
  AND WaitListEntry.status = :status