Create
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Products
See all
Community resources
Top groups
Explore all groups
Community resources
Learn
Community resources
Celebration

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root

Avatar

1 badge earned

Collect

Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!

Challenges
Coins

Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.

Recognition
Ribbon

Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!

Leaderboard

Join now to unlock these features and more

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

Vanessa Weigand
Vanessa Weigand
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
Get involved
Nov 13, 2023

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

Answer
Watch
Like Be the first to like this
105 views

1 answer

0 votes
Trudy Claspill
Trudy Claspill
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
Become a leader
Nov 13, 2023

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.

Reply

Suggest an answer

Log in or Sign up to answer
Jira Software
Jira Software
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
FREE
PERMISSIONS LEVEL
Site Admin
TAGS
AUG Leaders

Atlassian Community Events

See all events