Query to list all issue linked to an Epic?

[MK]

I need JQL query for below:

1. I would like to list all the issues(bug, story, task etc) linked to an Epic(just one single epic, not all the epics in a project), does not include sub-tasks.
2. List all issues and their sub-tasks linked to an Epic(just one single epic, not all the epics in a project).

[Fazila Ashraf · Accepted solution]

Do you mean epic link or just a normal link? Below are the queries for epic link:

1. "Epic Link" = ABC-1

2. "Epic Link" = ABC-1 OR parent in ("ABC-1")

[Tarun Sapra]

Hello@Fazila Ashraf

"2. "Epic Link" = ABC-1 OR parent in ("ABC-1")"

This will fetch the direct sub-tasks of the Epic but not the sub-tasks of the stories, bugs connected to the epic.

[Fazila Ashraf]

@Tarun Sapra  , you are right.. i actually misunderstood the question that the issues and the subtasks are to be pulled (but actually it is 'their' subtasks)..  Thanks for alerting :)

[Tarun Sapra · Accepted solution]

Hello @MK 

If you just want to find story, bugs etc connected to Epic then you should use

"Epic Link" = <epic-issue-key>

But if you want to list also the sub-tasks of the stories/bugs etc that are connected to epic then it's not possible to do that in default Jira. You need a plugin. If you have portfolio plugin then you can do

issuekey in childIssuesOf("ABC-34")

Here ABC-24 is the epic key and this will list all the child issues of epic and the sub-tasks of the child issues as well.

[MK · Accepted solution]

All Suggestions, works like a charm!

Thank you guys!!

I used below to fulfill my search criteria...

issuekey in childIssuesOf(CAPSGDM-204) AND status != Done) ORDER BY updated DESC    -------> List all issues & subtasks in an epic

[Vibha Sachdeva]

I have list of 100 epics and it's associated issues(User Story, Bugs etc.) in my Project's backlog.

Now I want to display only 15 epics and it's associated issues(User Stories, Bugs, etc.) on my Team's Scrum board Backlog.

For example: Out of 100 epics, I want to use E1, E2, E3, E4----E10 and display it's associated issues like US1, US2---US10, Bug1, Bug2--Bug10 on my Team's Scrum board backlog.

Current Query I'm using for my board is as below:

project = TP AND "Epic Link" in (E1, E2, E3, E4, E5, E6, E7, E8, E9, E10) OR id in (E1, E2, E3, E4, E5, E6, E7, E8, E9, E10) ORDER BY Rank ASC

Problem: This query is working for me and giving all the child issue types associated with the aforementioned epics. But in future the size of this query will grow by adding every time a new epic is introduced.

So can anyone please suggest how can I narrow down this growing query size ?

1)Scenario 1 : without a plug-in 

2)Scenario 2: with a plug-in

[Peter Bengov · Accepted solution]

Hi @MK 

I would lead you to an answer I gave in the past: https://community.atlassian.com/t5/Jira-questions/Show-list-of-linked-issues-from-a-number-of-issues/qaq-p/273189

These variations will help you get the data you want.