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 groups are described in this section. These queries are based on the information presented in this chapter.

The following query retrieves information about a group named zone1_all:

SELECT group_name, group_address, owner_name, group_admin
FROM dm_group
WHERE group_name = 'zone1_all'

The following query retrieves the names of the groups that a user named John is a member of, directly or indirectly (through nested group memberships):

SELECT group_name
FROM dm_group
WHERE ANY i_all_users_names = 'John'

The following query retrieves the names of the users and groups that are direct members of a group named zone_all:

SELECT r_object_id, users_names, groups_names FROM dm_group WHERE group_name = 'zone_all' ...

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