Epic with issues

[Raoul Kaiser]

I am using Jira Cloud trying to find all epics with issues that have been started (in development) or closed. Does anyone have a good JQL for this or Jira Automation I can start with?

[Bill Sheboy · Accepted solution]

Hi @Raoul Kaiser 

Short answer: you cannot do a nested query like this with out-of-the-box JQL

Longer answer and work-arounds:

What you could do instead depends upon frequency of need, costs, effort, and scope:

• Need this often and for the entire instance
  • please check your instance to learn if you have any marketplace addon apps to enhance JQL
  • if not, purchase an app which supports this capability
• Need this once and for one project
  • export your issues to a spreadsheet, including the epic link/parent information
  • filter your results
  • pull out the epic keys you need
• Need this occasionally and willing to do some work
  • create automation rules in your instance which mark epics when their children move to "in progress" or "completed".  This could be as simple as changing the epic's status.  You may then just query the epics for your information.
  • or, create a scheduled trigger automation rule which checks for issues with epics meeting your criteria, and report on the list of epics.  This will be limited by the 100 issue processing limit for automation rules.

Kind regards,
Bill

[Raoul Kaiser]

I don't have to do it often so it is possible to do it manually, but I went ahead and created an automation trigger for it. I got the number down to under 100 enough and have automation to mark the epics as started and completed so hopefully I shouldn't have to many problems.

[Bill Sheboy]

The started rule is easy: if a child starts work start the epic.

For the completed rule, did you check all the children before moving the epic to completed?

Thanks!

[Raoul Kaiser]

Yes. The great thing was I just had to keep looking around. Found the automated rule in the automation library and tweaked it a little for me.