User - group information on JIRa

Pilar
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
September 21, 2015

Hi

I want to know which database table holds the information on which users are member of which groups.?

Pilar

1 answer

1 vote
Taha Khanzada
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
September 21, 2015

Hi Pilar,

To get Group membership details you can use table called cwd_membership

To get user belongs to which all groups

Select * from cwd_membership where child_name = 'user_name'

To get list of users in particular groups

select USER_NAME, DISPLAY_NAME, EMAIL_ADDRESS from cwd_user
where lower_user_name in (select child_name from cwd_membership where parent_name = 'group_name')

Taha

Suggest an answer

Log in or Sign up to answer