nFeed select from JIRA tables doesn't allow "IN"

[Nancy Blackwell]

I want to get a list of users that belong to a group, my query is

SELECT user_name, first_name, last_name FROM cwd_user WHERE ID IN(SELECT child_id FROM cwd_membership WHERE parent_name = 'AIR_CAT_WRITE_GRP')

This query works fine in as SQL in SQL Manager, however get no results in nFeed. If I simplify the query to use use just one table like this:

SELECT user_name, first_name,last_name
FROM cwd_user
WHERE id IN (23171,24282)

I still get no results. However, if I change the query to

SELECT user_name, first_name,last_name
FROM cwd_user
WHERE user_name LIKE '%req83%'

I get results. So, it appears that I can't use the SQL keyword "IN"? Is there another method to get what I am looking for?

[Nancy Blackwell · Accepted solution]

formatting error. All is well.