Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,361,506
Community Members
 
Community Events
168
Community Groups

Search for epics with issues in another specific project

Florent06 I'm New Here Sep 14, 2022

All my epics are stored in a project A but all their stories are in other projects.

I want to get all epics that have issues in a specific project B :

issueFunction in issuesInEpics("project = B")

 

But this does not get any ticket. When I just search "project = B", I get a full list of tickets.

 

All the tickets I want to get are linked to epics in project A.

2 answers

Hi @Florent06 

As you're on Jira Server, the correct answer is to get an app that provides JQL extensions you're looking for.


With standard JQL, you can only get a list of issues and export them to Excel for further processing. This works if you want to do a one-off analysis. If your use case is more dynamic than that, look beyond standard Jira.

Standard JQL doesn't easily allow it, but you can quickly find the results using our professional indexing service JQL Search Extensions

You can use this query to find all your  epics that have issues from other projects

issue in epicOf("project = B”)

Check out the documentation for more examples.

If you have any other questions, please contact our support. We’ll be happy to help you!
Best regards,
Maurício

0 votes

Hello @Florent06 

Welcome to the community.

issuesInEpics returns the child issues of Epics, where the Epics match the filter you specify in the parentheses. Refer to 

https://scriptrunner.adaptavist.com/latest/jira/jql-functions.html?_ga=2.258035530.1301043823.1663180277-1406361688.1663002443#_issuesinepics

If you want to get the Epics you need to use epicsOf.

issuefunction in epicsOf("project=B")

...will give you all the Epics that have child issues in project B.

If you want to additionally limit the results to only the Epics that are in project A then add this:

issuetype=Epic and project=A and issuefunction in epicsOf("project=B")

Suggest an answer

Log in or Sign up to answer