Operation Details
Description: Retrieves user's report details
Sterotype: nsmulti
SQL
SELECT
  ReportUserLink.reportUserLinkID,
  Report.reportID,
  Report.name,
  Report.title,
  Report.reportType,
  Report.urlPath,
  ReportUserLink.dateCreated
INTO
  :reportUserLinkID,
  :reportID,
  :name,
  :title,
  :reportType,
  :urlPath,
  :dateCreated 
FROM
  Report,
  ReportUserLink,
  UserLink 
WHERE ReportUserLink.reportID = Report.reportID 
  AND ReportUserLink.userID = UserLink.userID 
  AND UserLink.userID = :userID 
  AND ReportUserLink.reportID = :reportID