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.
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.