PSPRDMNODES_VW

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 Field Type Column Type Description
PORTAL_NAME Character(30) VARCHAR2(30) NOT NULL Portal Name (see PSPRDMDEFN).
PORTAL_HOSTNODENAM Character(30) VARCHAR2(30) NOT NULL Portal Host Node Name
URI_TEXT Long Character CLOB URI Text
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19