SQL to find PeopleSoft portal objects hidden from navigation | PeopleSoft Tutorial

Quickest way to find hidden portal objects [SQL]

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.

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.