How do I find menu navigation in PeopleSoft

JointLantic

3 years ago

How do I find navigation in PeopleSoft

SELECT RTRIM(E.PORTAL_LABEL)
|| ' >> ' || RTRIM(D.PORTAL_LABEL)
|| ' >> ' || RTRIM(C.PORTAL_LABEL)
|| ' >> ' || RTRIM(B.PORTAL_LABEL)
|| ' >> ' || RTRIM(A.PORTAL_LABEL)
FROM PSPRSMDEFN A LEFT JOIN PSPRSMDEFN B ON B.PORTAL_NAME = A.PORTAL_NAME AND B.PORTAL_OBJNAME = A.PORTAL_PRNTOBJNAME LEFT JOIN PSPRSMDEFN C  ON C.PORTAL_NAME = B.PORTAL_NAME AND C.PORTAL_OBJNAME = B.PORTAL_PRNTOBJNAME LEFT JOIN PSPRSMDEFN D  ON D.PORTAL_NAME = C.PORTAL_NAME AND D.PORTAL_OBJNAME = C.PORTAL_PRNTOBJNAME LEFT JOIN PSPRSMDEFN E  ON E.PORTAL_NAME = D.PORTAL_NAME AND E.PORTAL_OBJNAME = D.PORTAL_PRNTOBJNAME WHERE A.PORTAL_URI_SEG2 = 'JOB_DATA'

SELECT RTRIM(E.PORTAL_LABEL)

|| ' >> ' || RTRIM(D.PORTAL_LABEL)

|| ' >> ' || RTRIM(C.PORTAL_LABEL)

|| ' >> ' || RTRIM(B.PORTAL_LABEL)

|| ' >> ' || RTRIM(A.PORTAL_LABEL)

FROM PSPRSMDEFN A LEFT JOIN PSPRSMDEFN B ON B.PORTAL_NAME = A.PORTAL_NAME AND B.PORTAL_OBJNAME = A.PORTAL_PRNTOBJNAME LEFT JOIN PSPRSMDEFN C ON C.PORTAL_NAME = B.PORTAL_NAME AND C.PORTAL_OBJNAME = B.PORTAL_PRNTOBJNAME LEFT JOIN PSPRSMDEFN D ON D.PORTAL_NAME = C.PORTAL_NAME AND D.PORTAL_OBJNAME = C.PORTAL_PRNTOBJNAME LEFT JOIN PSPRSMDEFN E ON E.PORTAL_NAME = D.PORTAL_NAME AND E.PORTAL_OBJNAME = D.PORTAL_PRNTOBJNAME WHERE A.PORTAL_URI_SEG2 = 'JOB_DATA'

Result query

How to get navigation using process name in PeopleSoft?

SELECT DISTINCT RTRIM( REVERSE ( SYS_CONNECT_BY_PATH(REVERSE (portal_label), ' >-')) ,' >- ') PATH
FROM PSPRSMDEFN
WHERE portal_name = 'EMPLOYEE'
AND portal_prntobjname = 'PORTAL_ROOT_OBJECT'
START WITH portal_uri_seg2 IN (
SELECT DISTINCT pnlgrpname
FROM ps_prcsdefnpnl
WHERE prcsname = 'PTSF_GENFEED')
CONNECT BY PRIOR portal_prntobjname = portal_objname;

SELECT DISTINCT RTRIM( REVERSE ( SYS_CONNECT_BY_PATH(REVERSE (portal_label), ' >-')) ,' >- ') PATH

FROM PSPRSMDEFN

WHERE portal_name = 'EMPLOYEE'

AND portal_prntobjname = 'PORTAL_ROOT_OBJECT'

START WITH portal_uri_seg2 IN (

SELECT DISTINCT pnlgrpname

FROM ps_prcsdefnpnl

WHERE prcsname = 'PTSF_GENFEED')

CONNECT BY PRIOR portal_prntobjname = portal_objname;

Query Result

Referrence 1: https://hmahanta.blogspot.com/2021/07/useful-quesries-in-peoplesoft.html
Referrence 2: https://www.shyamsblog.com/2010/10/how-to-get-navigation-using-process.html