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 |