membersOf()

[Shneior Dicastro]

Hi,

I try to get query that shows all member of the group "QA-HH",

is there a way to get the information as  memberOf() function do? 

Thanks 

Shneior

[Fabio Racobaldo _Herzum_]

Hi Shneior,

at what level you need to get this information? At DB level, at application level? 

memberOf() is a JQL Function that allows you to filter something based on user mermebrship. For example, this query retrieve all issue whose assigne is a member of QA-HH group 

assignee in memberOf("QA-HH")

If you need to retrieve users in that group you can access User Management->Group find this group and you will have a list of all users within. You need to be a Sys Admin to do that. If not ask to your Sys Admin.

Ciao,

Fabio

[Shneior Dicastro]

Thanks for your answer

I need it in DB level  sql query

[Fabio Racobaldo _Herzum_]

Hi @Shneior Dicastro ,

here your query :

select cu.user_name, cu.display_name, cu.email_address
from cwd_membership cm
inner join cwd_user cu on (cm.child_id=cu.ID)
where cm.parent_name = 'YOUR_GROUP_NAME_HERE';

If it's ok, please mark my answer as accepted.

Fabio

[Andreas]

Did you try this solution here: https://community.atlassian.com/t5/Jira-questions/MySQL-query-to-return-users-in-specific-groups/qaq-p/407461 ?

[Shneior Dicastro]

select * from cwd_membership; 

I can't find "cwd_membership" table

why?

[Andreas]

this query works on all of our servers. Maybe you're on the wrong database?

[Shneior Dicastro]

ok, i think it's internal permission issue in my organisation(Qualcomm)