PSTILEIMG_VW

 index back

Tile IMG View

Grabs the actual Image Data for the refered Tile Image in Fluid Attributes tab in portal registry. Grabs SVG Images only
SELECT A.PORTAL_NAME , A.PORTAL_OBJNAME , A.PORTAL_REFTYPE , A.IMAGE_FIELD , B.CONTDATA FROM PSNUITILE_VW A INNER JOIN PSCONTFRMT_VW B ON A.IMAGE_FIELD=B.CONTNAME WHERE B.CONTFMT IN ('svg', 'SVG') UNION ALL SELECT C.PORTAL_NAME , C.PORTAL_OBJNAME , C.PORTAL_REFTYPE , D.CONTNAME , D.CONTDATA FROM PSNUITILE_VW C , PSCONTENT D WHERE D.CONTNAME='PTNAVSRCH_DEF_ICN' AND C.IMAGE_FIELD NOT IN ( SELECT E.CONTNAME FROM PSCONTSVG_VW E)

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.
CONTIMG Image / Attachment CLOB Content Data
index back (c)David Kurtz 2020, www.go-faster.co.uk PeopleTools 8.58
PTRef generated on 21-DEC-20