Need a DQL that gives the name of the group (group name starting with 'ecm_')

Hi,

I need a DQL that gives the name of the group (group name starting with 'ecm_') of a user assuming that the user will be a member of only one group whose name starts with 'ecm_'.

Please share your knowledge and experiences for figuring this out.

Thanks.

Find more posts tagged with

Note:

If there are Accepted Answers, those will be shown by default. You can switch to 'All Replies' by selecting the tab below.

Accepted answers

DavidHaveman

Try this query:

select group_name from dm_group where any i_all_users_names = 'USERNAME' and group_name like 'ecm%'

If you're sure the user is only in one group, you can drop the "and group_name like 'ecm%' " clause...

All comments

DavidHaveman

Try this query:

select group_name from dm_group where any i_all_users_names = 'USERNAME' and group_name like 'ecm%'

If you're sure the user is only in one group, you can drop the "and group_name like 'ecm%' " clause...

athati

Thank you very much David. It is perfectly working.

Thanks again for your help.

DavidHaveman

Glad it worked out for you!