JQL Get issue with a linked issue that is in an epic

[Joshua Denenberg]

I want to get a list of issues from one project (Project_A) where they have any linked issue from a different project that is part of an epic. Is this possible? A query like:

project = ProjectA  AND issue in linkedIssues(project=Project_B AND "Epic Link" = Epic_A)

[Mohamed Benziane · Accepted solution]

Hi,

Welcome to the community.

Is not possible out of the box. You can look at some addon (scriptrunner or other) to achieve this. 

[Joshua Denenberg]

Thanks!

[Jack Nolddor _Sweet Bananas_]

Hi Joshua,

Sadly you cannot achieve the desired search using standard features on Jira, you must go for a third-party app instead. Using i.e. JQL Booster Pack you can type the following:

1) Search for issues from one project where they have any linked issue from a different project that is part of an epic

project = Project_A AND issue in linkedIssuesOf(' project = Project_B AND "Epic Link" = Epic_A' )

(*) Note that this is just an example, you must tune above query to fit your needs, such as using issueFunction field instead of issue if you are using Script Runner.

Using this app you can also query other issues relations, check:

• epicsOf()
• hasSubtasks()
• issuesInEpics()
• linkedIssuesOf()
• parentsOf()
• portfolioChildOf()
• portfolioParentOf()
• subtasksOf()

References:

• Official documentation