Is there a way to search all calls that have a specific Attachment by file name?

Version 2

    Details

    Is there a way to search all calls that have a specific Attachment by file name?


    Resolution

    The following Call Group criteria allows the end user to type the full name of an attachment file or a partial of the filename and it will return all Call Tickets with that name (partial name) as the  attachment:

    {CallLog.CallID} IN

     

    (SELECT GName

     

    FROM HEATGen

     

    WHERE Gcode = 'AT' AND GDetail LIKE '%' + @Prompt('Enter Title of Document') + '%')