How do I find navigation in PeopleSoft
|
1 2 3 4 5 6 |
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?
|
1 2 3 4 5 6 7 8 9 |
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