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

Question

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.

John Drury · Answer

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

Alexey Matveev · Answer

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.

Venkatesan Andila Muthukumarasamy · Answer

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