E.3 Determining the Navigation Collection Images

Navigation Collection images are listed as an attribute on the portal registry structure. The attributes are part of the registry structure managed object, however, the image itself is a separate object that must be included in the project definition to be copied.

Note:

Navigation images can be listed on the Navigation Collection definition objects as well as on normal portal registry folders. To ensure the same end-user experience, include all images listed on any content reference attribute. Do not include the common PeopleSoft PeopleTools or PeopleSoft Enterprise Components images, since these already exist in the PeopleSoft Interaction Hub and should not be overwritten.

To determine the Navigation Collection images:

1. Use a SQL query tool to access the content provider database.

2. Run the following SQL query to retrieve the Navigation Collection image names.

   The listed values under the column PORTAL_ATTR_VAL are the image names used on a Navigation Collection object.

   The attribute value is stored as a long char in the database.

   Not all database platforms allow a distinct clause on the fetched column value, so you may get duplicate results from the query.

   Replace the string <PREFIX> with the prefix used on delivered content provider portal registry structures, for example, HC, EP, CR, PF.

   SELECT PORTAL_ATTR_VAL FROM PSPRSMSYSATTRVL 
   WHERE PORTAL_ATTR_NAM = 'PTPP_IMAGE' 
   AND PORTAL_OBJNAME LIKE '<PREFIX>%'