Sub query to pull user stories from Epics and belonging to a different project

[David Capelle]

We have a project called PHA, it's a master project, that will hold all Epics, Epics are populated with User Stories.

Those User Stories come from PHA or any other projects.

How can I pull all the User Stories from those Epics?  I found the following but it requires to add each Epic manually, I am looking for a way that will pull the Epics directly. Thanks.

project = PHA AND issuetype = Epic OR "Epic Link" in (PHA-1, PHA-2, PHA-3)

[Mikael Sandberg · Accepted solution]

I don't think you can do it in core JQL, but if you have JQL Tricks (on JIRA Server) you could search for all issues that have epics corresponding to a specific JQL, like this:

issue in issuesWhereEpicIn("project = \"PHA\"")

[David Capelle · Accepted solution]

Thank you @Mikael Sandberg for your input.  I think I just got to a solution, using script runner.

This will list all linked issues to the Epics from the Project

issueFunction in linkedIssuesOf("project = PHA", "is epic of")