Showing all closed stories within a subset of epics in JIRA filter

[Eva Popov]

Hi all,

I would like to see a list of all closed stories that are within all open epics with a particular priority. My challenge is how to overcome the parent-child relationship in the query. So what I am trying to do is really to merge the two following queries:

1) list all closed user stories from a particular project

project = xyz AND issuetype in (Bug, "Change Request", Improvement, Incident, "New Feature", Task) AND status in ("Passed Testing", Closed, Abandoned, "Pending UAT", "UAT Testing Done", "Deployed to Production")

2) that are assigned to any open Epic with a critical priority within the same project

project = xyz AND type = Epic AND priority in ("Critical [P1]") AND status not in ("Deployed to Production", Closed, Abandoned)

Manual solutions like adding a list of epics by uid is not an option as this list changes overtime. My workaround for the time being was to add the list manually but it changes far too often for this to be acceptable solution. (e.g. in the closed story query adding "AND "Epic Link" in (xyz-1156, xyz-4743, ........)")

Any ideas how to have both of those combined in one filter?

Thanks!

[Bill Sheboy · Accepted solution]

Hi @Eva Popov  -- Welcome to the Atlassian Community!

As you have discovered, JQL is not a SQL; it is to support simple searches and focus board contents. Thus it cannot do things like join result sets, etc.

Your two simple options to accomplish what you ask are to:

• purchase a marketplace add-on to extend the features of JQL
• export the data to spreadsheet tools, and perform the joins/analysis outside of Jira

Best regards,

Bill

[Eva Popov]

Hi @Bill Sheboy  ,

Thanks for a warm welcome and your answer!

It is as I unfortunately thought. I will look into the other options, thanks for suggestions.

Best regards,

Eva