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
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 ChrisPeopleSoft 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.
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.