nested JQL without plugins (on cloud)

[Marek Dziedzic]

Hello,

I've been looking through a number of questions/support articles, and I cannot seem to find anything that answers my question already.

I am trying to create a nested JQL query so that I can get all of the Epics and their subsequent stories that are In Progress. Something like:

"Epic Link" in ('list of Epics where the Epic Status = "in progress"') OR parentEpic in ('list of Epics where the Epic Status = "in progress"')

The desired result would be something like:

Epic-1

Story-in-epic-1-1

Story-in-epic-1-2

Story-in-epic-1-3

Epic-2

Story-in-epic-2-1

Story-in-epic-2-2

Story-in-epic-2-3

Where the status of Epic-1 and Epic 2 is "in progress".

Note that some of the stories above may NOT be "in progress", so I cannot leverage the status of the stories for this filter.

[Marcus Hunger]

This is so frustrating. If you ever consider Jira, beware that basic functionality is missing. Users are expected to buy upgrades from a marketplace, just to organize their backlog properly.

[Daniel Turczanski - JQL Search Extensions]

Hi Marek,

Nested JQL is not supported out of the box in Jira.

An alternative to using an app like JQL Search Extensions that support subqueries, is to manually create the results:

1. search for epics that are in progress
2. export to Excel and copy the epic issue keys
3. create a query that fetches children of a _static_ issue list from the second step