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

How do I write the jql to list all the defects and stories in an epic

Bernard O'Flynn Jan 31, 2013

In GH I can see all the stories in an epic on the planning view.

However I can't seem to figure out how GH knows that?

I've tried writing a JQL but the Epic in Jira doesn't list the stories and defects as sub-things.

I need to send the stories in an epic to a manager.

How do I get the jql to list the epic and all the associated stories and defects

1 answer

1 accepted

0 votes
Answer accepted
Matthew Cobby Jan 31, 2013

There is a custom field called "Epic/Theme" and you just query it.

"Epic/Theme" = 'MYPROJECT-1'

where MYPROJECT-1 is the ID of the Epic

Bernard O'Flynn Jan 31, 2013

Brilliant - thanks!

Bernard O'Flynn Jan 31, 2013

Hmmm...that's not available. Do I need the latest version of GH? I have 6.1.0

Mark DeMichele Jan 31, 2013

That's odd, I used something like this and it worked.

project = XL AND Epic = XL-538 ORDER BY Rank ASC, key ASC

This is in classic mode.

Matthew Cobby Jan 31, 2013

I think the field changes name depending what version you have. The test server I had today was quite an old one.

Suggest an answer

Log in or Sign up to answer
This widget could not be displayed.
This widget could not be displayed.
Community showcase
Published in Jira Software

How to prevent the propagation of unused project schemes, workflows & screens in Jira software

Atlassian ranks project attributes as the third most important factor impacting performance in the category of data. It’s not surprising, since project attributes are precisely the rules used to ma...

1,382 views 1 17
Read article

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