adm_my_recent_documents_v
One row per document the ADM user established in the current session worked with last, with the time and kind of the last action.
Overview
Section titled “Overview”Group: Application integration
Category: Documents - Core document analysis and reporting
Use Cases
Section titled “Use Cases”- A Recent list in your own application
- Showing what a user did last
Columns
Section titled “Columns”The view contains 9 columns providing comprehensive information:
| Column Name | Description |
|---|---|
document_id |
The document. Joins to adm_my_documents_v.document_id. The unique key of this view. |
document_name |
Name of the document, including its extension. |
folder_id |
The folder holding the document. |
folder_path |
Full lowercase path of the containing folder. |
document_path |
folder_path and document_name joined with a slash. A convenience, not an identifier. |
file_mime_type |
MIME type of the document. |
last_action |
Audit action type of the latest event: VIEW_DOCUMENT, DOWNLOAD_DOCUMENT, CREATE_DOCUMENT, ADD_DOCUMENT_VERSION, MERGE_DOCUMENT_VERSION or RESTORE_DOCUMENT_VERSION. |
last_action_at |
When the latest event happened. |
action_count |
How many events the user had on the document since it entered the list. |
Key Features
Section titled “Key Features”- Unique by document_id
- last_action is the audit action type of the latest event
- At most RECENT_DOCUMENTS_LIMIT rows per user
- No order is implied; order by last_action_at desc
Related Views
Section titled “Related Views”Other views in the Documents category: