Quickest way to find hidden portal objects [SQL]

 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.