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?
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.
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.
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