JIRA On-Demand Querying by parent

Question

I'm using the On Demand version of Jira. I need a filter that will show me:

All issues within a particular epic AND all sub tasks of those issues.

So effectively:

• Epic
  • Story 1
    • Sub Task 1
    • Sub Task 2
  • Defect 1
  • Story 2
    • Sub Task 3
    • Sub Task 4
    • Defect 2

Plugins are not an option here as I'm using the OnDemand version. Any suggestions on how I can achieve the above without having to link all sub tasks to the epic?

Answer 1

Question is quite old but since 13 January 2017 Jira Cloud (previously OnDemand) supports a parentEpic:

parentEpic = Epic-1

this will find the epic itself, with all the stories/tasks in the epic and their sub-tasks, it was previously not possible without installing add-ons.

Answer 2

I think following query will help you to get expecting result:

project = project name AND "Epic Link" = 'epic name'..

Answer 3

With JIRA OnDemand, you are severely limited in the kinds of queries you can run. OnDemand and self-hosted actually have same default JQL features, but the self-hosted does allow for a ton of add-ons for JQL.

I've solved this problem personally by first using the JIRA CLI to get a dump of all the issues in a project into a local CSV. Then, I use csvkit to make tables/CSV that I actually need (i.e. All descendant issues of a parent epic).