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.
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!
Welcome to the community.
issuesInEpics returns the child issues of Epics, where the Epics match the filter you specify in the parentheses. Refer to
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")