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 File > Open > Image and click the Open button.

• In 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.