I was composing this post when there was a comment from “Spamboy” for my previous post where he provided the SQL to identify the portal navigation. Thanks for your comments!!

In this post I will share the SQL I use when I want to determine the portal navigation. Here it is …

SELECT LPAD(‘–‘,2*(LEVEL-1)) || PORTAL_LABEL “NAVIGATION”

FROM (SELECT PORTAL_LABEL, PORTAL_PRNTOBJNAME, PORTAL_OBJNAME, PORTAL_URI_SEG2 FROM PSPRSMDEFN A

WHERE PORTAL_NAME = ‘EMPLOYEE’ ) B

WHERE B.PORTAL_PRNTOBJNAME != ‘ ‘

START WITH (B.PORTAL_URI_SEG2 IN

(SELECT D.PNLGRPNAME

FROM PSMENUITEM A, PSMENUDEFN B, PS_PRCSDEFNPNL C, PSPNLGROUP D

WHERE A.MENUNAME=B.MENUNAME

AND A.PNLGRPNAME = C.PNLGRPNAME

AND A.PNLGRPNAME = D.PNLGRPNAME

AND PRCSNAME LIKE UPPER(‘&PRCSNAME’))

)

CONNECT BY PRIOR B.PORTAL_PRNTOBJNAME = B.PORTAL_OBJNAME;

NAVIGATION

———————————-

Load Transactions into AM

–Load Transactions

–Send/Receive Information

–Asset Management

Also, if you have built the search index (PeopleTools > Portal > Build Registry Search Index) and know the component name. You can directly enter the component name in the search box. Here is what you get.

Portal_search_2

Posted by Nitin Pai
Comments (0)
August 23rd, 2007

Comments (0)