User Name |
COGIPF_USERLOGON.USERNAME
|
Report Name |
"if
(COGIPF_VIEWREPORT.REPORT PATH = 'null' ) then ('Unsaved
report') else if (COGIPF_VIEWREPORT.REPORT PATH = '') then
('Unsaved report') else if ( position('/report',
COGIPF_VIEWREPORT.REPORT PATH)>0) then (substring
(COGIPF_VIEWREPORT.REPORT PATH, position('/report',
COGIPF_VIEWREPORT.REPORT PATH)+15, position('', substring
(COGIPF_VIEWREPORT.REPORT PATH, position('/report',
COGIPF_VIEWREPORT.REPORT PATH)+15)) -2)) else if (
position('/interactiveReport', COGIPF_VIEWREPORT.REPORT
PATH)>0) then (substring (COGIPF_VIEWREPORT.REPORT PATH,
position('/interactiveReport', COGIPF_VIEWREPORT.REPORT
PATH)+26, position('', substring (COGIPF_VIEWREPORT.REPORT PATH,
position('/interactiveReport', COGIPF_VIEWREPORT.REPORT
PATH)+26)) -2)) else ('Unsaved report')" |
Report Type |
upper(substring
(COGIPF_VIEWREPORT.TARGET TYPE , 1, 1) )+
lower(substring(COGIPF_VIEWREPORT.TARGET TYPE , 2,
character_length(COGIPF_VIEWREPORT.TARGET TYPE ) - 1))
|
Report Format |
if
(COGIPF_VIEWREPORT.REPORT FORMAT = 'SearchResult for
COGIPF_REPORTFORMAT') then ('Format unspecified') else
(COGIPF_VIEWREPORT.REPORT FORMAT ) |
Report Search Path |
trim (COGIPF_VIEWREPORT.REPORT
PATH) |
Time Stamp |
COGIPF_VIEWREPORT.TIME STAMP
|
Error Details |
COGIPF_VIEWREPORT.ERROR DETAILS
|
Package |
"if
(COGIPF_VIEWREPORT.PACKAGE = 'null') then (' ') else if
(COGIPF_VIEWREPORT.PACKAGE = '' ) then (' ') else
if(position('/package', COGIPF_VIEWREPORT.PACKAGE)>0)
then(substring (COGIPF_VIEWREPORT.PACKAGE, position('/package',
COGIPF_VIEWREPORT.PACKAGE)+16, position('', substring
(COGIPF_VIEWREPORT.PACKAGE, position('/package',
COGIPF_VIEWREPORT.PACKAGE)+16))-2) ) else (substring
(COGIPF_VIEWREPORT.PACKAGE , 1, character_length(
COGIPF_VIEWREPORT.PACKAGE)))" |
Status |
upper(substring
(COGIPF_VIEWREPORT.STATUS , 1, 1) )+
lower(substring(COGIPF_VIEWREPORT.STATUS , 2,
character_length(COGIPF_VIEWREPORT.STATUS ) - 1))
|