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

[Bernard O'Flynn]

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

[MatthewC · Accepted solution]

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]

Brilliant - thanks!

[Bernard O'Flynn]

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

[MatthewC]

Ahh, you dind't say 6.1 ;-)

try "Epic Link",

https://confluence.atlassian.com/display/GH/GreenHopper+JIRA+Configuration#GreenHopperJIRAConfiguration-Customfields

Epic/theme is in classic boardshttps://confluence.atlassian.com/display/GH/Working+with+Epics+in+GreenHopper+Classic

[Mark DeMichele]

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.

[MatthewC]

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