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

[Venkatesan Andila Muthukumarasamy]

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.

[Venkatesan Andila Muthukumarasamy]

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

[Alexey Matveev]

You would need to use ScriptRunner for it:

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

[Venkatesan Andila Muthukumarasamy]

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

[Alexey Matveev]

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.

[John Drury]

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