Show epics that had updated child issues during a time period

[Rachel Grundy]

I'm trying to show a list of epics which had child issues that were updated within a certain time period, and hitting a brick wall with my JQL query. I have a query to bring up a list of ALL issues under certain parent issuetypes, but I don't want to see all the stories & tasks, just the parent epics.

This is to ultimately display in a list on a Confluence page (or visualize in some way).

Any suggestions?

[Hannes Obweger - JXL for Jira · Accepted solution]

Hi @Rachel Grundy

unfortunately, I don't think you can solve this with "plain" JQL - you'll likely need an app from the Atlassian Marketplace. 

There's two directions that you could take:

• There are various apps that extend JQL by custom functions. I'm not an expert in any of these apps, but I know that e.g. JQL Search Extensions is very popular. Maybe someone else can speak for concrete solutions in this space.
• I believe you should be able to create the list of issues with one of the more hierarchy-focused apps, like Structure, or JXL for Jira (the app that my team is working on) - not so much through JQL, but through custom filtering capabilities within the app.

I can, of course, only speak for JXL. Here's how this would work: 

• Create a JQL statement that includes a.) any child issue (e.g., of type "Story" etc.) with an "updated date" within the time range you're interested in, plus b.) any possible epic issues. Don't worry about the parent/child relationships at this stage.
• In JXL, enable the issue hierarchy view. This will show your issues in their parent/child relationship. This can be done with one click.
• In the resulting issue hierarchy, filter out any epics without children. Again, this can be done with one click.
• The remaining set of epics are all epics with children that have been updated within the time frame you're interested in ✅
• You can now e.g. export this list of epics to Excel or CSV, or bulk-edit them to add a label, etc. etc.

As said before, I can only speak for JXL, but I would assume that you can do similar things with other apps, too.

Hope this helps,

Best,

Hannes | https://jxl.app

[Rachel Grundy]

Thanks Hannes!