DQL help needed - to find the email addresses of all users in multiple groups each group name starti

Hi,

I am trying to formulate a DQL to find the email addresses of all users in multiple groups each group name starting with 'some'. If you can, please post it.

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

athati

I think I got it,

select user_address from dm_user where user_state=0 and user_name in (select i_all_users_names from dm_group where group_name like 'ecm_%')

Thanks.

All comments

athati

I think I got it,

select user_address from dm_user where user_state=0 and user_name in (select i_all_users_names from dm_group where group_name like 'ecm_%')

Thanks.

shree.thota

you can write DQL like this also

select user_address from dm_user where user_group like '%groupname%'

yamangoyal

select user_address from dm_user where user_name in(select distinct i_all_users_names from dm_group where group_name like 'ceo%');