adm_my_document_annotations_v

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

Access scope — Application integration

Follows adm_my_documents_v exactly, which is the same rule adm_annotations_api enforces: view rights on the document 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 the file metadata ADM extracted on upload
• Reading key-value metadata your own application wrote
• Filtering documents by an annotation value

Columns

The view contains 9 columns providing comprehensive information:

Column Name	Description
annotation_id	Primary key of the annotation.
document_id	The annotated document. Joins to adm_my_documents_v.document_id.
annotation_key	The annotation key, always lowercase. Unique per document.
annotation_value	The annotation value, free text up to 4000 characters. May be null.
key_namespace	FILE for a key in ADM”s reserved “file.” prefix (technical metadata extracted from the file itself, rewritten on every new version), CUSTOM for anything the host application wrote. Never write a “file.” key yourself.
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 (document_id, annotation_key)
• key_namespace separates ADM’s reserved file.* keys from your own
• A metadata bag, not referential integrity

Related Views

Other views in the Annotations category:

• adm_my_folder_annotations_v