(private) sorry...!! contact@ecmnotes.com

Virtual Documents

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

Leave a Reply