Query/filter to get the EPIC and all its line items in a single query

Leo Nishanth Anthony

we have created an EPIC 123 which has field called consumer filled example "Public"

This epic has 3 sub items(backlog items) 

A.1

A.2

A.3 

Now I have a another epic called 456 which has field called consumer filled example "Public"

Now I have a another epic called 789 which has field called consumer filled example "Internal"

 

How can create a query which will show me 

Epic 123

Epic 456

A.1

A.2

A.3

We cannot, unfortunately, use any add-on due to some internal constraints. How best can I achieve my requirement?

Thanks in advance for your help and support.

francis

Check out scriptrunner.

It provides a jql 'issuesInEpic'  which allows you to select all the required 'line items'

 

A jql (= advanced search) selecting your epics and underlying issues can be constructed such as 

 

issueFunction in issuesInEpics("project = ABC") or (project=abc and issuetype=epic)

 Hope this helps