How do I find all the stories associated with multiple epics?

Question

I need to make a report showing progress on various themes.  Our themes are broken into epics, which are owned by teams.  How do I use JQL to find all of the stories associated with the epics under a given theme?

Using JQLT I can get a list of the Epics.  But I cannot use

"Epic Link" in ("filter = 'epicslistgenerator'")

where epicslistgenerator is the filter which gives me a list of epics (whose stories I want to capture).

Robert Leitch [ALM Works] · Answer

Hi Greg,

If you're using our Structure plugin you can get there by grouping your Epics and using S-JQL as per the example in this post.

Instead of grouping by team, you would group your Epics under a Theme container in Structure, then with an S-JQL query like

issue in structure("structure_name", "child of (child of issue_id)")

you can retrieve children-of-children of the Theme, i.e. Stories.

You can use that query wherever JQL is accepted.

Jobin Kuruvilla [Adaptavist] · Answer

What exactly is a theme here? You try something like this with JQLT:

issue in issuesWhereEpicIn("criteria to get the epics")