Updating Navigation Collection Links to Render Out

E.7 Updating Navigation Collection Links to Render Out

The copied content provider Navigation Collection links are likely defined to render from the portal where they were created. The link portal name must be set to render out of the current portal, instead of the original portal name.

To update the Navigation Collection Link Portal:

Use a SQL query/update tool to access the PeopleSoft Portal Solutions database.
Run the following SQL query statement to check the rows that you will be updating.

Replace the string <MY_NEW_SITE> with the portal name of the site created.

Replace the string <PREFIX> with the prefix used on delivered content provider portal registry structures, for example, HC, EP, CR, PF.
```
SELECT * FROM PSPRSMDEFN 
WHERE PORTAL_NAME = '<MY_NEW_SITE>'
AND PORTAL_OBJNAME LIKE '<PREFIX>%'
AND PORTAL_PRODUCT = 'CFAN' 
AND PORTAL_CREF_USGT = 'LINK'
```
Run the following SQL update statement to update the link portal name.

Replace the string <MY_NEW_SITE> with the portal name of the site created.

Replace the string <PREFIX> with the prefix used on delivered PeopleSoft content provider portal registry structures.

For example, HC, EP, CR, PF, and so on.
```
UPDATE PSPRSMDEFN SET PORTAL_LINK_PORTAL = PORTAL_NAME
WHERE PORTAL_NAME = '<MY_NEW_SITE>'
AND PORTAL_OBJNAME LIKE '<PREFIX>%'
AND PORTAL_PRODUCT = 'CFAN' 
AND PORTAL_CREF_USGT = 'LINK'
```