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.

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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.

Accepted answers

Trudy P Claspill

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

All comments

Trudy P Claspill

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.