Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
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

Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,465,499
Community Members
 
Community Events
176
Community Groups

Jira query for In Progress Stories wirh no subtasks In Progress

I'm trying to build a query that will return stories with a status = In Progress where there are no subtasks In Progress. Any suggestions? I'm stuck! JCL is an option.

1 answer

1 accepted

0 votes
Answer accepted
Trudy Claspill Community Leader Nov 30, 2022

Hello @Jodi Hughes 

Welcome to the community.

What do you mean by "JCL"? Do you mean JQL (Jira query language) or are you referring to some third party app?

Are you using Jira Server or Jira Data Center? What version are you using?

What do you need to do with the results once you have them? 

Apologies! Bad typing & a long day!  I intended to say JQL.

I'm using jira core server v8.20

The query results will be displayed in a dashboard to alert the user's. Stories that are in progress without subtasks in progress need their attention.

Thanks!

Trudy Claspill Community Leader Dec 01, 2022

Do you have any third party apps available to you that extend JQL capabilities, such as Adaptavist Scriptrunner or JQL Search Extensions?

I don't believe you can accomplish this without a third party app.

If you have Adaptavist Scriptrunner I think this would work:

project = <your project> and type not in subtaskIssueTypes() and status="In Progress" and issuefunction in hasSubtasks and not issuefunction in parentsOf("status='In Progress'") 

Worked beautifully! Thank you so much!

Trudy Claspill Community Leader Dec 01, 2022

If your question has been adequately answered it would be great if you can mark the Answer as Accepted. That helps other community users find posts that have working solutions.

Suggest an answer

Log in or Sign up to answer
TAGS

Atlassian Community Events