JQL for EPIC issues report

[bharat.jilka]

How to create a JQL query to extract all the issues in an EPIC and also all related issues for the issues listed in the EPIC.

[Jack Nolddor _Sweet Bananas_]

Hi bharat,

There are some ways (some of them out-of-the-box and other using a third-party app)

You can run the following query to retrieve some data:

"Epic Link" = EPIC-1234 OR parent = EPIC-1234

However above query will not retrieve subtasks under issues linked to the epic only will display subtasks created under the epic itself it will neither return linked issues.

As you can see the query above does not meet the expectations if you need to query a range of Epics (e.g "Done" Epics). So a better option will be tu use a third-party app that enhance your search capabilities.

Using i.e. JQL Booster Pack you can type the following:

- Retrieve subtask issues created directly under Epic
- Retrieve issues under Epic and also their subtasks
- Retrieve any issue related (using issue linking feature) to the issues collected above

"Epic Link" = EPIC-1234 OR parent = EPIC-1234 OR issue IN subtasksOf('\"Epic Link\" = EPIC-1234') OR issue in linkedIssuesOf("\"Epic Link\" = EPIC-1234 OR parent = EPIC-1234 OR issue IN subtasksOf('\"Epic Link\" = EPIC-1234')")

(*) This is only an example, I will be glad to help you to create the real JQL if you share with us some screens to see the issue relations. You can also can tune the query to meet your needs as your own and use this one as a base.

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

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

References:

• Official documentation

Hope this helps you to create awesome queries <3

Kind regards

[bharat.jilka]

Hi Jack

I'll give you suggestion a try and get back to you.

Thank you

Bharat

[Jack Nolddor _Sweet Bananas_]

Nice! if you need further support, please don't hesitate to reply this message.

[Victor Mutambuki]

Welcome Bharat,

See similar answered question.

Victor