How to list out the Profile Attachments in the Classic HEAT Database.

Details

How to list out the Profile Attachments in the Classic HEAT Database.

Resolution

The Profile attachments in HEAT Classic are not stored in the database. The physical files are stored in a folder structure designed by the HEAT Administrator. When attaching a file to a Profile record, the path to and name of the file are stored in the database as a link to the proper file from the folder structure.

To find all the links to Profile attachments, run the following query against the HEAT Classic database: