PSNUITILE_VW

 index back

NUI Tile View

View: Left outer join of PSPRSM_SRCH_VW and PSPRSMNUI to grab the Fluid Attributes tab info from portal registry
SELECT A.PORTAL_NAME , A.PORTAL_OBJNAME , A.PORTAL_REFTYPE , CASE WHEN (B.IMAGE_FIELD=' ' OR B.IMAGE_FIELD IS NULL) THEN 'PTNAVSRCH_DEF_ICN' ELSE B.IMAGE_FIELD END AS DEFAULT_IMAGE FROM PSPRSM_SRCH_VW A LEFT OUTER JOIN PSPRSMNUI B ON A.PORTAL_NAME=B.PORTAL_NAME AND ((A.PORTAL_OBJNAME=B.PORTAL_OBJNAME) OR (A.PORTAL_LINKOBJNAME=B.PORTAL_OBJNAME)) AND A.PORTAL_REFTYPE=B.PORTAL_REFTYPE

PeopleSoft Field Name Field Type Column Type Description
PORTAL_NAME Character(30) VARCHAR2(30) NOT NULL Portal Name (see PSPRDMDEFN).
PORTAL_OBJNAME Character(30) VARCHAR2(30) NOT NULL Portal Object Name
PORTAL_REFTYPE Character(1) VARCHAR2(1) NOT NULL Portal Reference Type
C=Content
F=Folder
IMAGE_FIELD Image Reference(30) VARCHAR2(30) Image Reference Field to display images used in Personalizations explanations.
index back (c)David Kurtz 2020, www.go-faster.co.uk PeopleTools 8.58
PTRef generated on 21-DEC-20