Is there a way to determine the request an attachment is associated with?

[mruscetta]

FNCI 6.x -- attachments to requests are kept under  {install-dir}/config/core/attachments/{mmddyyyy}_ {nnnnnnnnn}_{username}_{attachment filename}

I am not sure what the {nnnnnnnnn} number is -- I assume it is a timestamp?

Is there a way to determine from this filename what request the file is attached to?

It would very useful if an attachment name could be mapped back to the request to which it is attached.

thanks,

  Michelle

[alexrybak]

Michelle,

You can get the request ID associated with a given attachment from the database using the query below:

SELECT ENTITY_ID_ FROM PAS_ATTACHMENT WHERE ENTITY_TYPE_ = 'R' AND NAME_ = 'ATTACHMENT_FILE_NAME';

Hope that helps,

-Alex