Is it possible to JQL on a subtask based on that status of other subtasks?

[Gil]

Hi.

In a given parent issue, I have 3 subtasks.

1 subtask is like a placeholder. I'd like the JQL to return the status of that 1 subtask if the other subtasks are in Done.

Is it possible to do so without ScriptRunner?

[Kristian Walker _Adaptavist_]

Hi Gil,

Thank you for your question.

I can confirm that it is possible to search for issues which have a certain number of subtasks using the numberOfSubtasks() JQL aliased provided by ScriptRunner for Jira Cloud as described here.

You can also search for subtasks which meet a specified condition with ScriptRunner for Jira Cloud using the subtasksOf() Enhanced Search function as described here.

It is not possible in Jira cloud to have a hierarchy where a subtask can have a subtask below itself as Atlassian do not provide the functionality between this which means that you are restricted to only have a hierarchy of Issue > subtask.

If this response has answered your question can you please mark it as accepted so that other users can see it is correct when searching for similar answers.

Regards,
Kristian

[Tarun Sapra]

Hello @Gil   on Cloud you can use something like

parent is not empty and parent = OK-3

Here OK-3 is the parent issue and thus it returns all the sub-tasks as JQL doesn't just return the status but the issue. Hence if you want to see "not done" issues you can change the query to

 parent is not empty and parent = OK-3 and status != Done

[Tarun Sapra]

The above query returns all sub-tasks which have parent - OK-3 and which are not done.

I think this is the best you can do on cloud out of the box, if you want more complex things then you will need a plugin.