You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
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.
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?
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'")
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.