O'Reilly logo

Documentum 6.5 Content Management Foundations by Pawan Kumar

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Help—some DQL Queries

Some helpful queries related to object types are provided in this section.

The following query retrieves the types of sysobjects matching a condition:

SELECT r_object_id, object_name, r_object_type
FROM dm_sysobject
WHERE object_name = 'loan_app.pdf'

The following query retrieves all the null types:

SELECT name
FROM dm_type
WHERE super_name = ' '

The following query retrieves the supertype of a given type:

SELECT super_name
FROM dm_type
WHERE name = 'dm_document'

The following query retrieves the names and labels for attributes of a given type:

SELECT attr_name, label_text
FROM dmi_dd_attr_info
WHERE type_name = 'dm_sysobject'

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required