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.