Useful Queries: Virtual Document

List all direct children of a specific virtual document (identified by object ID):

select r_object_yd from dm_sysobject in document id(‘09003214af93028c’)

List all children of a specific virtual document, including components of nested virtual documents:

select r_object_id from dm_sysobject in document id(‘09003214af93028c’) descend with any r_version_label = ‘CURRENT’

List all parent virtual documents to which a specific document belongs (identified by object ID):

select r_object_id from dmr_containment where child_id = (’09f5a5cb8000892b’)

List all documents that are virtual documents:

select object_name from dm_document where r_is_virtual_doc = 1

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: