Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Query to list all issue linked to an Epic?

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).

 

 

4 answers

4 accepted

1 vote
Answer accepted
Fazila Ashraf Community Leader May 21, 2019

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")

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.

Like MK likes this
Fazila Ashraf Community Leader May 21, 2019

@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 :)

0 votes
Answer accepted
Peter Bengov Community Leader May 21, 2019

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. 

0 votes
Answer accepted
Tarun Sapra Community Leader May 21, 2019

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.

0 votes
Answer accepted

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

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

Suggest an answer

Log in or Sign up to answer
TAGS

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you