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.