FileFolder View Attachment History


Hi, I am attempting to create¬† SQL code to count how often a certain set of files have been viewed (GET not autovue).¬† I’d be grateful if someone could point me towards the relevant table/view. The ATTACHMENT_FULL_MAP view i believe, only contains info for files which have been viewed via autovue, checkin and checked out. not GET. Thanks you for taking the time to read this.

Agile User Asked on March 20, 2020 in Agile PLM (v9).
Add Comment
1 Answer(s)
Best answer

You will want to look in the ITEM_HISTORY table. That table has a history of activity. Out-of-the-box, not all file (attachment) operations are recorded in history. For instance, viewing a file. If you need to capture viewing then there is a configuration setting to enable recording that in history.

Agile Angel Answered on March 20, 2020.

Thank you for your assistance Steve

on March 23, 2020.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.