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

Version 1

    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:


    SELECT *

    FROM HEATGen

    WHERE GCode = 'AP'