How to write a query based on value in Issue's parent's fields

[George Carvill]

Is there a way to do a query that says, show me the subtasks where the subtask parent's field x has value "y"

[George Carvill · Accepted solution]

Thanks.

Turns out I have solved my immediate problem with the Craftforge JQL functions plugin: https://plugins.atlassian.com/plugin/details/31601

A nice person at Atlassian support pointed me here:

http://stackoverflow.com/questions/5153024/filter-to-show-sub-tasks-of-a-filtered-list-of-parent-tasks

[Ramiro P]

nice... taking note about this plugin :D

[JamieA]

Script runner (free) has similar functions: subtasksOf, parentsOf. You might find that the script runner versions are significantly faster than the other ones.

[George Carvill]

You may well be right, but we haven't gone down the ScriptRunner path yet.

[JamieA]

You don't need to actually use the scripting functionality to get all the other stuff, ie jql functions, workflow functions etc.

[Ramiro P]

Hi George, you could use the JQL tricks plugin: https://marketplace.atlassian.com/plugins/com.j-tricks.jql-plugin

Sadly it's not free, but it has exactly what you need:

Subtask Functions

• parent(JqlQuery) <--------
• subtask(JqlQuery)
• hasSubtasks([subtaskType])