how to limit the user lookup to a group


 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?


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'


You should replace 'some-group-name' with the actual group name.

Use the "\" char to create a multiline query.