Operation Details
Description: @deprecated by searchByUserNameAndType. Searches for bookmark of a certain type for the current user
Sterotype: nsmulti
SQL 
SELECT
  Bookmark.bookmarkID,
  Bookmark.referenceNo,
  CaseHeader.caseReference,
  CaseHeader.caseTypeCode,
  ConcernRole.concernRoleID,
  ConcernRole.concernRoleName,
  CaseHeader.startDate,
  CaseHeader.statusCode
INTO
  :bookmarkID,
  :referenceNo,
  :caseReference,
  :caseTypeCode,
  :concernRoleID,
  :concernRoleName,
  :startDate,
  :statusCode 
FROM
  Bookmark,
  CaseHeader,
  ConcernRole 
WHERE Bookmark.userName = :userName 
  AND Bookmark.type = :type 
  AND Bookmark.referenceNo = CaseHeader.caseID 
  AND CaseHeader.concernRoleID = ConcernRole.concernRoleID 
ORDER BY CaseHeader.startDate DESC