It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

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

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?

1 answer

1 accepted

0 votes
Answer accepted

formatting error. All is well.

Suggest an answer

Log in or Sign up to answer
Community showcase
Published in Marketplace Apps & Integrations

Now Available: AWS Service Catalog Connector for Jira Service Desk

We are excited to share that AWS Service Catalog Connectors for Jira Service Desk (JSD) Cloud and JSD Server/Data Center are now available in the Atlassian Marketplace. Users can now request admin-ap...

566 views 0 3
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you