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 · Accepted solution]

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

[Leo Nishanth Anthony]

@francis Thank you for the reply.

For some internal reason, no apps are allowed in the system. I was wondering if this possible out of the box?

Regards
Leo

[Leo Nishanth Anthony]

@Francis Martens (iDalko) I was trying the following 

filter 1

project = XXX AND "Epic Link" in ("123", "456")

filter 2

project = XXX AND consumer ~ public

Filter 3

filter in ("Filter1", "Filter 2")

The only problem is the list wont be dynamic and i have to add the newly created epic to the filter 1 everytime.

Business Reason : I have to use this filter in scrum board.

[Leo Nishanth Anthony]

Any help here would be appreciated