0

SQL to find PeopleSoft portal objects hidden from navigation

You can hide PeopleSoft portal objects (e.g. content reference) from PeopleSoft Navigation. This can be done by navigating to ‘Structure and Content’ and selecting  the checkbox ‘Hide from portal navigation’.

Navigate to PeopleTools > Portal > Structure and Content 

Incase you don’t have access to this page to view the configuration, you can check this via SQL.

Below is the SQL that can be used to determine content reference that are hidden from portal navigation.

-- Find if a portal object is hidden i.e. 'Hide from Portal Navigation' checkbox is enabled
-- Below query will return the result only if object is hidden

SELECT *
  FROM PSPRSMSYSATTRVL
 WHERE     portal_name = 'EMPLOYEE'
       AND PORTAL_ATTR_NAM = 'PORTAL_HIDE_FROM_NAV'
       AND portal_Reftype = 'C'
       AND PORTAL_OBJNAME IN (SELECT PORTAL_OBJNAME
                                FROM PSPRSMDEFN
                               WHERE PORTAL_LABEL LIKE '%your_portal_label%');

In our example, portal_label would be ‘Connections‘ (WHERE PORTAL_LABEL LIKE ‘%Connections%’))

Above SQL will give a result if the portal label is hidden i.e. the checkbox ‘Hide from Portal Navigation’ is selected for that object under Structure and Content.

This SQL can come in handy when you don’t want to navigate to Portal online to view the access or simply don’t have access to portal navigation.