How to show epics where no story, task or sub-task has been started

[Michael Green]

Hi,

I am trying to write a Filter to produce a list of Epics on the Backlog where an Epic has had no work done on it at all i.e:

1. None of the Epic's Stories or Sub-Tasks have been started

2. None of the Stories in the Epic have Tasks that have been started

Is there a way to do this with JQL ?

[Walter Buggenhout]

Hi @Michael Green,

No, not really with out of the box functionality. JQL is quite powerful, but lacks a bit of flexibility when it comes to searching by related work items.

There are marketplace apps available that extend these capabilities. If that's an option you are open to explore, this list might be useful to explore.

You can, however, work around that with automation. This is a typical use case where keeping workflow statuses aligned between parent and child items comes in handy. If you could automate your workflows so that when a first story / sub-task changes status, you automatically also update the status of its parent's items accordingly, you can solve your requirement by simply searching by epic status.

In human language: If your epic workflow is To Do > In Progress > Done and a first child story changes to an in progress status, make sure you automate the parent epic's status to In Progress. All your epics with status To Do then become the ones where no work has been done at all.

Hope this helps!