Component Navigation using SQL

In this video we are talking about finding out how to navigate to a component through the PeopleSoft navigator if all you have is a component name.

Enterprise Components

Navigation: Home > Enterprise Components > Find Object Navigation

Enterprise components is a convenient way to find navigation to a component or a page given only a component, page or secondary page name. This utility is part of the Enterprise Components group, not the PeopleTools group. It may not yet be implemented in all PeopleSoft Applications as of this writing. The video demonstration used HCM 9.2.

SQL

Use this SQL to find all navigation paths to a component.   

Replace [component] with the component name.   

SELECT DISTINCT REVERSE(LTRIM(SYS_CONNECT_BY_PATH (REVERSE(PORTAL_LABEL),' >- '),' >- '))
FROM PSPRSMDEFN P
WHERE PORTAL_OBJNAME = 'PORTAL_ROOT_OBJECT'
START WITH PORTAL_URI_SEG2 = '[component]'
CONNECT BY PRIOR PORTAL_PRNTOBJNAME = PORTAL_OBJNAME
AND PORTAL_NAME = PRIOR PORTAL_NAME
AND PORTAL_REFTYPE = 'F';

This sql can also be modified to work for a list of components

   URI_SEG2 in ( '[component]','[component]','[component]'...)

Finding Page Navigation

Navigation is by components, not page. So first find the which component(s) where the page is used:

     SELECT * FROM PSPNLGROUP where pnlname = '[page]';

Then use the above Component Navigation SQL with your component name to find the navigation to that page.

Helpful Table Names for this demo

• PSPNLGROUP (Which pages are in a component)
• PSPNLGRPDEFN (Component Definition Information)
• PSPNLDEFN (Page Definition)
• PSPNLFIELD (Record Fields used on a page)