Where can I find the link/pointers to each individual Call attachment?

Version 1

    Details

    Where can I find the link/pointers to each individual Call attachment?


    Resolution

    All Call Ticket Attachment information is stored in the DB in a table named HEATGen.  Each CallID that has an attachment is set as a row with a GCode column value of AT (for attachment) and a GName value of the actual CallID. The physical details for the Attachment (file name, location, etc.) is stored in that same row in the GDetail column.

    In order to extract the file name and location, for example a specific CallID, you could run something similar to below.  This is an example pulled from the demo DB for CallID 00000022:

    SELECT GName, GDetail
    FROM HEATGen
    WHERE (GName = '00000022' AND GCode = 'AT')

    The results in the GDetail column if pulled out would look like this:
    [Info]
    NumAttachments=2

    [Attachments]
    Attachment1=changing name|C:\Program Files (x86)\HEAT\Documents\LGPL 2.1.pdf
    Attachment2=testing two |D:\data\janie.chung\userdata\My Pictures\BELOW 20.png