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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.