How I can know that users are only included in a group?

Eva Fernández October 19, 2016

Hello,

How I can know that users are only included in a group?

 

Now the query, I see users who are in a group. But I need to see those who are only in a particular group. I want to see that users are "only" included in the "jira-users" group.

 

    select * from jira.cwd_membership where parent_name = 'jira-users';

 

Thank!!!

Eva - from spain

 

1 answer

1 accepted

0 votes
Answer accepted
Peter Geshev
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.
October 19, 2016

Hi Eva,

You can try the following query 

SELECT m.* 
FROM cwd_membership m
LEFT JOIN cwd_membership m1 ON m1.CHILD_ID = m.CHILD_ID AND m1.PARENT_ID <> m.PARENT_ID
WHERE m.parent_name = 'jira-users' AND m1.id IS NULL

Regards,

Peter

Eva Fernández October 19, 2016
it works!! Thank you very much!

Eva

Suggest an answer

Log in or Sign up to answer