Loading...

Follow Jeff's PeopleSoft Blog on Feedspot

Continue with Google
Continue with Facebook
or

Valid
I am using Unified Navigation in my Portal (Interaction Hub) environment. When a database that is refreshed from production I needed a quick way to update the Unified Navigation configuration information with SQL. Here is the updates I have found useful in my environment. 


--Interaction Hub Unified Navigation refresh:
--Remote Content
UPDATE PS_PTUN_DDMENUCFG
SET MSGNODENAME = (SELECT MSGNODENAME FROM PSTRUSTNODES WHERE MSGNODENAME LIKE 'HR%'), 
DESCR30 = (SELECT MSGNODENAME FROM PSTRUSTNODES WHERE MSGNODENAME LIKE 'HR%'),
PORTAL_OBJNAME1 = (SELECT MSGNODENAME FROM PSTRUSTNODES WHERE MSGNODENAME LIKE 'HR%') || ':PORTAL_ROOT_OBJECT'
WHERE MSGNODENAME = '<HR_PRODUCTION_NODE>';

UPDATE PS_PTUN_DDMENUCFG
SET MSGNODENAME = (SELECT MSGNODENAME FROM PSTRUSTNODES WHERE MSGNODENAME LIKE 'CS%'), 
DESCR30 = (SELECT MSGNODENAME FROM PSTRUSTNODES WHERE MSGNODENAME LIKE 'CS%'),
PORTAL_OBJNAME1 = (SELECT MSGNODENAME FROM PSTRUSTNODES WHERE MSGNODENAME LIKE 'CS%') || ':PORTAL_ROOT_OBJECT'
WHERE MSGNODENAME = '<CS_PRODUCTION_NODE>';

--Message Nodes
--HCM Node
UPDATE PSUN_CFGHNODE
SET MSGNODENAME = (SELECT MSGNODENAME FROM PSTRUSTNODES WHERE MSGNODENAME LIKE 'HR%')
WHERE MSGNODENAME = '<HR_PRODUCTION_NODE>';

--Campus Node
UPDATE PSUN_CFGHNODE
SET MSGNODENAME = (SELECT MSGNODENAME FROM PSTRUSTNODES WHERE MSGNODENAME LIKE 'CS%')
WHERE MSGNODENAME = '<CS_PRODUCTION_NODE>';

--Structure & Content
UPDATE PSPRSMDEFN 
SET PORTAL_LABEL = (SELECT MSGNODENAME FROM PSTRUSTNODES WHERE MSGNODENAME LIKE 'HR%')
WHERE PORTAL_CNTPRV_NAM = '<HR_PRODUCTION_NODE>';

UPDATE PSPRSMDEFN 
SET PORTAL_LABEL = (SELECT MSGNODENAME FROM PSTRUSTNODES WHERE MSGNODENAME LIKE 'CS%')
WHERE PORTAL_CNTPRV_NAM = '<CS_PRODUCTION_NODE>';

--Folder Attributes
UPDATE PSPRSMSYSATTRVL 
SET PORTAL_ATTR_VAL = (SELECT MSGNODENAME FROM PSTRUSTNODES WHERE MSGNODENAME LIKE 'HR%')
WHERE PORTAL_ATTR_VAL LIKE '<HR_PRODUCTION_NODE>';

UPDATE PSPRSMSYSATTRVL 
SET PORTAL_ATTR_VAL = (SELECT MSGNODENAME FROM PSTRUSTNODES WHERE MSGNODENAME LIKE 'CS%')
WHERE PORTAL_ATTR_VAL LIKE '<CS_PRODUCTION_NODE>';

UPDATE PSPRSMSYSATTRVL 
SET PORTAL_ATTR_VAL = (SELECT MSGNODENAME FROM PSTRUSTNODES WHERE MSGNODENAME LIKE 'CS%') || ':PORTAL_ROOT_OBJECT'
WHERE PORTAL_ATTR_VAL LIKE 'CS%ROOT%';

UPDATE PSPRSMSYSATTRVL 
SET PORTAL_ATTR_VAL = (SELECT MSGNODENAME FROM PSTRUSTNODES WHERE MSGNODENAME LIKE 'HR%') || ':PORTAL_ROOT_OBJECT'
WHERE PORTAL_ATTR_VAL LIKE 'HR%ROOT%';






Read Full Article
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

Separate tags by commas
To access this feature, please upgrade your account.
Start your free month
Free Preview