Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Next challenges

Recent achievements

  • Global
  • Personal

Recognition

  • Give kudos
  • Received
  • Given

Leaderboard

  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

How to find whether all the sub tasks in a list of stories got closed?

I have list a of 250 story (issuetype = story) in a Sprint and all those are either in closed or open status and in each story, I have two sub tasks (one for Developer & other for tester). 

Now I want to do a search to find out,

- In that particular Sprint - the story which are in closed status - however the sub tasks was not closed in those story.

Sprint 

Total story

Story in closed status

Story in open status

Total sub-tasks

Expected sub-tasks in closed status

Actual sub-task in closed status

S01

250

100

150

500

200

50

 

From my above example, the query should fetch the results of missing 150 sub-tasks which needs to be closed.

2 answers

0 votes

You would need to use ScriptRunner for it:

sprint = "Sprint 1" and issueFunction in parentsOf("status != Closed") and status = Closed

Thanks Alexey.

As I said earlier, I have 2 sub-tasks in a story by using the query which you shared its fetching the records even if one sub-tasks is closed. 

Parent story - Open status

Developer sub-tasks - Closed 

Tester sub-tasks - Open

I think, if you want to check that all of the subtasks are not closed, then you need to write your own JQL function. You can do it in Power Scripts or ScriptRunner. In my opinion, it is easier in Power Scripts to write a jql function.

"issueFunction" and and "parentsOf" are not available in Jira

 

Is there a way to pass on the query to differentiate the check on sub-task? 

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Posted in Jira Software

Presenting the "Best of 2020" Jira Software roundup!

Catch up with Atlassian Product Managers in our 2020 Demo Den round-up! From Advanced Roadmaps to Code in Jira to Next-Gen Workflows, check out the videos below to help up-level your work in the new ...

281 views 2 7
Join discussion

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you