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 alias sets are described here. These queries are based on the information provided in this chapter.

The following query retrieves aliases (names, values, and types) present in an alias set:

SELECT alias_name, alias_value, alias_category
FROM dm_alias_set
WHERE object_name = 'zone1_aliases'

The following query assigns an alias set (using its object ID) to a sysobject explicitly:

UPDATE dq_loan_app OBJECTS
SET r_alias_set_id = '6600001080000500'
WHERE object_name = 'LoanApp_1234567890.txt'

Note that r_alias_set_id can be modified like this even though its name starts with r_.

The following query retrieves the performer names for an activity:

SELECT performer_name FROM dm_activity WHERE object_name ...

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