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 NameField TypeColumn TypeDescription
PORTAL_NAMECharacter(30)VARCHAR2(30) NOT NULLPortal Name (see PSPRDMDEFN).
PORTAL_HOSTNODENAMCharacter(30)VARCHAR2(30) NOT NULLPortal Host Node Name
URI_TEXTLong CharacterCLOBURI Text
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19