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
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
Thanks for your answer
I need it in DB level sql query
Did you try this solution here: https://community.atlassian.com/t5/Jira-questions/MySQL-query-to-return-users-in-specific-groups/qaq-p/407461 ?
select * from cwd_membership;
I can't find "cwd_membership" table
why?
this query works on all of our servers. Maybe you're on the wrong database?
ok, i think it's internal permission issue in my organisation(Qualcomm)
Hi @Shneior Dicastro ,
here your query :
select cu.user_name, cu.display_name, cu.email_addressfrom cwd_membership cminner 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.
It looks like you're new here. Sign in or register to get started.
