JQL: Show Epics in Status "in realisation" with no tasks in status "in progress"

[Vanessa Weigand]

When we start working on an epic, the corresponding tasks in the epic are set to "in progress" and the epic itself is set to "in realization"

I would like to see the epics for which there are no tasks in progress, but which are incorrectly "in realization" because no work is being done on them and the epics belong back in the backlog

Does somebody know how to create such a JQL query Show Epics in Status "in realisation" with no tasks in status "in progress" 

Thanks a lot

Vanessa

[Trudy Claspill]

Hello @Vanessa Weigand 

Welcome to the Atlassian community.

It is not possible to construct that query without adding a third party app to your instance. Are you willing to consider a third party app?

The ScriptRunner for Jira app would enable you to do that, and they do support it being free for instances with no more than 10 users (like the Free subscription for Jira Software itself).

https://marketplace.atlassian.com/apps/6820/scriptrunner-for-jira?hosting=cloud&tab=overview

There may be others that provide the same functionality and also remain free for <10 users. SR is the one I know the best.