PSTILEIMG_VW

(SQL View)
 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 PeopleSoft Field Type Database Column Type Description
1 PORTAL_NAME Character(30) VARCHAR2(30) NOT NULL Portal Name (see PSPRDMDEFN).
2 PORTAL_OBJNAME Character(30) VARCHAR2(30) NOT NULL Portal Object Name
3 PORTAL_REFTYPE Character(1) VARCHAR2(1) NOT NULL Portal Reference Type
C=Content
F=Folder
4 IMAGE_FIELD Image Reference(30) VARCHAR2(30) Image Reference Field to display images used in Personalizations explanations.
5 CONTIMG Image / Attachment CLOB Content Data