cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
mruscetta
Level 3

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

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

Labels (1)
0 Kudos
(1) Reply
alexrybak
Revenera
Revenera

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

0 Kudos