Question about

[Durell Demartini]

Hello,

Is it possible using JQL "issueFunction" (or perhaps another way) to get a list of sub-tasks within parent tickets of a certain issue type and status?  

So, something like:

• issueFunction in subtasksOf("'issuetype' IN ('Virtual Machine') ") - these sub-tasks

• Parent issuetype = "Virtual Machine" and status = "Patching" - But only from the Parent tickets that are in "Patching" status

I've tried this, but the sub-tasks of an issue are not considered linked issues, so this query doesn't show the sub-tasks:

issueFunction in linkedIssuesOf("status = 'Patching'") and resolution is empty

Thanks in advance for any assistance you can offer.

[Trudy Claspill · Accepted solution]

Hello @Durell Demartini 

Do you have ScriptRunner or another JQL-extending app on your instance? "issueFunction" is used to call non-native JQL functions that are often provided by a third party app.

There are a few apps that could give you what you want.

ScriptRunner has the subtasksOf() function

https://docs.adaptavist.com/sr4js/latest/features/jql-functions/included-jql-functions/sub-tasks

JQL Search Extensions has a SubTaskOf() function

https://appfire.atlassian.net/wiki/spaces/JQLSEARCH/pages/604209587/JQL+Search+Extensions+Server+Data+Center#JQLSearchExtensions(Server/DataCenter)-SubTaskOf(jql-query)

JQL Tricks has a parent() function

https://www.j-tricks.com/jqlt-subtask-functions.html

[Durell Demartini]

Hi @Trudy Claspill we have ScriptRunner. We were hoping not to have to leverage another addon for now.

[Trudy Claspill]

Then you can use the ScriptRunner subtasksOf() function

https://docs.adaptavist.com/sr4js/latest/features/jql-functions/included-jql-functions/sub-tasks

issueFunction in subtasksOf("issuetype = 'Virtual Machine' and status = 'Patching'")