Get Started: AI Resources for Oracle Cloud HCM – Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
case statement was producing only 3 records instead of 6 records in FINAL_PATH Column
Hi All,
need help on below case. i am concatenating the different structure of Reports Url's (BIP,OTBI,DASHBOARD) with POD url along with report path. Here FLV.DESCRIPTION column i have stored different report paths like., /shared/custom/hcm/....xdo.
Query:
SELECT DISTINCT FLV.MEANING as REPORT_NAMES,
FLV.DESCRIPTION , FLV.TAG,
--'https://'||POD.EXTERNAL_VIRTUAL_HOST||'/xmlpserver'||FLV.DESCRIPTION||'?_xmode=' AS REPORT_PATH_1,
-- 'https://'||POD.EXTERNAL_VIRTUAL_HOST||'/analytics/saw.dll?Portal&PortalPath='||FLV.DESCRIPTION AS REPORT_PATH_2,
FLV.LOOKUP_CODE,
(
CASE FLV.TAG
WHEN 'DASHBOARD' THEN '
Tagged:
0