Find Portal CREF in Navigation

By Chris Malek | Wed, Oct 13, 2010

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.

Article Categories
Author Info
Chris Malek

Chris Malek is a PeopleTools® Technical Consultant with two decades of experience working on PeopleSoft enterprise software projects. He is available for consulting engagements.

About Chris Work with Chris
Looking for pain-free PeopleSoft web services? 😀
PeopleSoft Simple Web Services (SWS)

Introducing a small but powerful PeopleSoft bolt-on that makes web services very easy. If you have a SQL statement, you can turn that into a web service in PeopleSoft in a few minutes.

Book
Integration Broker - The Missing Manual

I am in the process of writing a book called "Integration Broker - The Missing Manual" that you can read online.