How do we check the physical presence of a file in the File Vault ?
We have some attachments that would not open up when clicked on the file link, Get or View option.
How do I verify if the files are present or deleted from the Vault ?
Find the ID for the file from the FILES table in the database. Easiest is to look for the file name, but if it isn’t unique, you’ll have to track back through ATTACHMENT_MAP to make sure you are getting the correct ID that you couldn’t pull up. Take the ID
FILE_ID is what is in ATTACHMENT_MAP and it is the ID from FILES. In AM, you need to look at PARENT_ID and PARENT_CLASS to find the object the file is linked to.
Just about every table in the Agile schema has an attribute named “ID”. it is always a unique numeric value for each record (and actually unique across all tables). It is used to link records in the schema without having to copy text values as key attributes. In ATTACHMENT_MAP, PARENT_ID is the ID from ITEM, or CHANGE, etc. based on the value of PARENT_CLASS (ITEM = 9000,10000, CHANGE=6000,7000,8000,11000,1450).