Operation Details
Description: Method searches the requests between the date ranges for the owner. This is accessed by <span lang="EN-IE" style="FONT-SIZE: 11pt; LINE-HEIGHT: 115%; FONT-FAMILY: 'Calibri','sans-serif'; mso-fareast-font-family: Calibri; mso-bidi-font-family: 'Times New Roman'; mso-ansi-language: EN-IE; mso-fareast-language: EN-US; mso-bidi-language: AR-SA">resource manager and resource manager supervisor</span>
Sterotype: nsmulti
SQL 
SELECT
  requestID,
  requestType,
  requestCategory,
  requestStatus,
  R.concernRoleID,
  dateCreated,
  dateSubmitted,
  rejectionReason,
  comments,
  R.versionNo
INTO
  :requestID,
  :requestType,
  :requestCategory,
  :requestStatus,
  :concernRoleID,
  :dateCreated,
  :dateSubmitted,
  :rejectionReason,
  :comments,
  :versionNo 
FROM
Request R INNER JOIN
  
  AdministrationConcernRole 
  ON (R.concernRoleID = AdministrationConcernRole.concernRoleID) INNER JOIN
  
  AdministrationRole 
  ON (AdministrationConcernRole.administrationRoleID = AdministrationRole.administrationRoleID) 
where 
R.datesubmitted >= :startDate 
and R.datesubmitted <= :endDate 
and AdministrationRole.userName = :userName