List all direct children of a specific virtual document (identified by object ID):
SELECT object_name, subject, authors FROM dm_sysobject IN DOCUMENT ID('')
List all direct children of a specific virtual document (identified by object ID and a version label):
SELECT object_name, subject, authors FROM dm_sysobject IN DOCUMENT ID('') VERSION 1.1
List all children of a specific virtual document, including components of nested virtual documents:
SELECT object_name, subject, authors FROM dm_sysobject IN DOCUMENT ID('') DESCEND
Return the identified virtual document and all children with late binding that match the WITH condition:
SELECT object_name, subject, authors FROM dm_sysobject IN DOCUMENT ID('') WITH ANY r_version_label = 'draft' AND title = ''
Return the identified virtual document and all children with late binding that match the WITH condition. If several versions of a child qualify, the server returns the top component sorted by r_creation_date in descending order:
SELECT object_name, subject, authors FROM dm_sysobject IN DOCUMENT ID('') WITH ANY r_version_label = 'draft' AND title = '' NODESORT BY r_creation_date, title DESC
Return the identified virtual document all its direct children. If a child is itself a virtual document from which a snapshot was created, the snapshot information is returned instead of the virtual document information:
SELECT object_name, subject, authors FROM dm_sysobject IN DOCUMENT ID('') USING ASSEMBLIES
Return information about a specified node within a snapshot:
SELECT object_name, subject, authors FROM dm_sysobject IN ASSEMBLY ID('objectid')NODE ID('objectid')
List the parent virtual documents to which a specific document belongs (identified by object ID):
SELECT r_object_id, object_name from dm_document WHERE r_object_id IN (SELECT parent_id FROM dmr_containment WHERE component_id=SELECT i_chronicle_id FROM dm_sysobject WHERE r_object_id = '')
List all documents that are virtual documents and have no child document:
SELECT object_name FROM dm_document WHERE r_is_virtual_doc = 1 and r_link_cnt =0