这个SQL是获取仪表盘路径的,你可以试试SELECT B.MENU_LEVEL, B.CMID, B.PCMID, B.MENU_NAME, &n...
显示全部
这个SQL是获取仪表盘路径的,你可以试试
SELECT B.MENU_LEVEL,
B.CMID,
B.PCMID,
B.MENU_NAME,
B.MENU_PATH,
REPLACE(LOWER(PKG_HTCG_ETL_COMMON.F_URL_ENCODE(B.MENU_PATH,
'UTF-8')),
'''',
'%27') ENCODED_PATH,
RPAD(' ', 2000) FULL_PATH,
B.DISPSEQ
FROM (SELECT A.MENU_LEVEL,
A.CMID,
A.PCMID,
A.MENU_NAME,
A.DISPSEQ,
DECODE(A.MENU_LEVEL,
1,
'/content/folder[@name=''' || A.MENU_NAME || '''' || ']',
DECODE(3 - A.MENU_LEVEL,
0,
'/report[@name=''' || A.MENU_NAME || '''' || ']',
'/folder[@name=''' || A.MENU_NAME || '''' || ']')) MENU_PATH
FROM (SELECT LEVEL MENU_LEVEL,
TR.CMID,
TR.PCMID,
TR.MENU_NAME,
TR.DISPSEQ
FROM (SELECT A.CMID,
A.PCMID,
B.NAME MENU_NAME,
A.DISPSEQ
FROM ODS.CMOBJECTS A, ODS.CMOBJNAMES B,ods.cmclasses c
WHERE A.CMID = B.CMID
and b.) TR
CONNECT BY PRIOR TR.CMID = TR.PCMID
START WITH TR.CMID = 599) A )b
收起