Find Portal CREF in Navigation

Here is a quick way to find where a component shows up in the portal navigation for a given component. In this example, we are going to find the navigation for the JOB_DATA component.

Step 1

Find the Portal Object Name the component was registered under. This object name will be returned by the PORTAL_OBJNAME column from the following SQL. Notice that the JOB_DATA component name is hard coded in the SQL.

  SELECT PORTAL_OBJNAME , PORTAL_URI_SEG2
  FROM PSPRSMDEFN
   WHERE PORTAL_NAME = 'EMPLOYEE'
   AND PORTAL_URI_SEG2 like'JOB_DATA' -- THIS IS THE COMPONENT NAME

Step 2

Use the Online Portal Page to look this portal object name.

Navigate to: PeopleTools | Portal |View Menu Item Detail

Then enter in the PORTAL_OBJNAME found above in the search record and the page will show you where the navigation is.