Generating a List of Images in the Image Catalog
To generate a list of images in the image catalog, you can:
In PeopleSoft Application Designer, select Open button.
and click theIn the query tool for your database platform, enter and run this SQL statement to list all image definitions:
SELECT DISTINCT CONTNAME FROM PSCONTDEFN WHERE CONTTYPE = 1.
In the query tool for your database platform, enter and run this SQL statement to the language-dependent versions of images, :
SELECT CONTNAME, LANGUAGE_CD, CONTTYPE CONTFMT DESCR FROM PSCONTDEFNLANG WHERE CONTTYPE = 1
Note: Before signing into PeopleSoft Application Designer in a different language, you must enable the language support. Use PeopleTools Utilities to enable support.
Create a query definition in PSQuery that uses the PSCONTDEFN record, the CONTNAME field from that record, and select for images where the CONTTYPE = 1 only.