adm_my_folder_annotations_v

One row per annotation on a folder the ADM user established in the current session may see.

Access scope — Application integration

Follows adm_my_folders_v exactly, which is the same rule adm_annotations_api enforces: view rights on the folder grant every annotation on it, and no key is withheld.

Overview

Group: Application integration

Category: Annotations - Document and folder key-value metadata

Use Cases

• Reading key-value metadata your own application put on a folder
• Marking a folder as the target of a business process
• Selecting folders by an annotation value

Columns

The view contains 8 columns providing comprehensive information:

Column Name	Description
annotation_id	Primary key of the annotation.
folder_id	The annotated folder. Joins to adm_my_folders_v.folder_id.
annotation_key	The annotation key, always lowercase. Unique per folder.
annotation_value	The annotation value, free text up to 4000 characters. May be null.
created_date	Timestamp the annotation was created.
created_by	User who created the annotation.
updated_date	Timestamp the annotation was last changed.
updated_by	User who last changed the annotation.

Key Features

• Unique by annotation_id, and by (folder_id, annotation_key)
• Every key is customer owned - ADM writes no folder annotations

Related Views

Other views in the Annotations category:

• adm_my_document_annotations_v