Tech Kraft

Documentum, AWS, Java, Ruby on Rails, Linux, Windows, App Servers


Documentum: DQL to List all groups a user belongs to

The DQL to query the list of groups that a user belongs to:

select group_name from dm_group where any users_names = ‘<user id>’;

To query all groups to which a user belongs whether directly or indirectly, use:

select group_name from dm_group where any i_all_users_names = ‘<user id>’;

To query for groups the logged in user belongs to, use:

select group_name from dm_group where any i_all_users_names = USER;

 

 



Leave a comment

About Me

Senior Software Engineer professional with over 16 years of success with multiple open source technologies and various Content Management platforms and solutions.

Proven technical abilities through numerous projects involving enterprise web application design and development, application installation, configuration and support, and workflow and collaboration system designs.

  • Ability to learn new technologies and platforms quickly and apply them to the task at hand.
  • Excellent analytical skills, and strong communication and collaboration abilities.
  • Technical emphasis in including but not limited to Java, Ruby on Rails, Documentum and Alfresco
    in both Linux and Windows based environments

Newsletter