You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
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.
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.
this query works on all of our servers. Maybe you're on the wrong database?