Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Next challenges

Recent achievements

  • Global
  • Personal

Recognition

  • Give kudos
  • Received
  • Given

Leaderboard

  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

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

Find tickets with assignee matching (or not matching) subquery

Hi Everyone,

I need a way to find a list of issues where an assignee value is in a sub query. For example, i have a list of issues underneath an epic Y. I want to find a list of all issues under a different project ABC that have the same assignees as in list Y.

Psudocode:  Show me all all issues in Project ABC where assignee in (select assignee from child issues of Epic Y)

 

Does anyone have any ideas on how to write that in JQL? or using scriptrunner functions?

2 answers

0 votes
Hana Kučerová Community Leader Jan 09, 2021

Hi @Stacy Zalesak ,

welcome to the Atlassian Community!

Do you have Cloud or Server or Data Center Jira?

Probably this could be done, if you create your Custom JQL Function using ScriptRunner, but I believe this option not available for cloud.

Hi Stacy,

Thank you for your question.

I can confirm that ScriptRunner for Jira Cloud provides the issueInEpics() and epicsOf() enhanced search functions that you would be able to use to search for issues in an epic and these may be useful to achieve your requirement if you are using Jira Cloud.

Regards,

Kristian

Thanks. i use those functions all the time but they dont help me find where an attribute (assignee) in my query matches the attribute of the tickets in the epic.

Hi Stacy,

Thank you for your response, I can confirm they can be used to search for where values match a certain query but the JQL does not support matching where a value such as an assignee matches the value of a field in another issue and you can only hardcode the values you require in your queries in Jira Cloud.

Regards,

Kristian

Suggest an answer

Log in or Sign up to answer
TAGS

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