Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Celebration

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root

Avatar

1 badge earned

Collect

Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!

Challenges
Coins

Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.

Recognition
Ribbon

Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!

Leaderboard

Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,459,138
Community Members
 
Community Events
176
Community Groups

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

2 answers

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

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

select * from cwd_membership; 

I can't find "cwd_membership" table

why?

Andreas Rising Star Mar 28, 2018

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) 

Like Laurisa likes this

Suggest an answer

Log in or Sign up to answer
TAGS

Atlassian Community Events