how to limit the user lookup to a group
Introduction
I would like to look up and only find users which are in certain groups - for a user field in a grid, like "select distinct lower_user_name from cwd_user order by lower_user_name "
Can this be extended to only look up users in a specific group?
Solution
This should be something like
SELECT distinct lower_user_name \
FROM jira.cwd_user cu \
inner join jira.cwd_membership cm on cu.user_name = cm.child_name \
where lower_parent_name = 'some-group-name'
Note!
You should replace 'some-group-name' with the actual group name.
Use the "\" char to create a multiline query.