PSPRDMNODES_VW

(SQL View)
 Index Back

Hosted Node Names Per Portal

This is used by Portal Menu Search (SES). Returns the actual node name, and portal content URI hosted by each Portal

SELECT A.PORTAL_NAME , CASE A.PORTAL_HOSTNODENAM WHEN 'LOCAL_NODE' THEN C.MSGNODENAME WHEN ' ' THEN C.MSGNODENAME ELSE A.PORTAL_HOSTNODENAM END , C.URI_TEXT FROM %Table(PSPRDMDEFN) A ,%Table(PTLCLBASEURI_VW) C WHERE A.PORTAL_HOSTNODENAM = 'LOCAL_NODE' UNION ALL SELECT A.PORTAL_NAME , CASE A.PORTAL_HOSTNODENAM WHEN 'LOCAL_NODE' THEN C.MSGNODENAME WHEN ' ' THEN C.MSGNODENAME ELSE A.PORTAL_HOSTNODENAM END , B.URI_TEXT FROM %Table(PSPRDMDEFN) A LEFT OUTER JOIN %Table(PSNODEURITEXT) B ON (A.PORTAL_HOSTNODENAM=B.MSGNODENAME AND B.URI_TYPE = 'PL' ) ,%Table(PTLCLBASEURI_VW) C WHERE A.PORTAL_HOSTNODENAM <> 'LOCAL_NODE'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PORTAL_NAME Character(30) VARCHAR2(30) NOT NULL Portal Name (see PSPRDMDEFN).
2 PORTAL_HOSTNODENAM Character(30) VARCHAR2(30) NOT NULL Portal Host Node Name
3 URI_TEXT Long Character CLOB URI Text