JQL search on children

[Stéphane Genin]

Hi,

I would like to find all issues that have children subtasks in a specific status, and also all issues that don't have children in a specific status.

Is it feasible with the default JQL features, or shall I develop my own plugin?

Thanks

Stéphane

[Jobin Kuruvilla [Adaptavist] · Accepted solution]

It is not feasible with the default search. JQL Tricks plugin has a subtask method to do this but to warn you, it is a commercial plugin.

[Filipe]

Hi,

Try if

https://marketplace.atlassian.com/plugins/pt.lt.lfcribeiro.jira.jqlLTFunctions

Solves your problem, nevertheless it will let you run SQL functions using executeQuery()

Regards,

[Norman Abramovitz]

You may want to look at look the following plugin. It is only tested up to version 4.4.5 but it might be easier to bring a plugin up to a version level verses writing the logic.

https://plugins.atlassian.com/plugins/org.craftforge.jira.craftforge-jql-functions-plugin

•issue in/not in parentIssuesFromFilter("filter name or its id")- finds all parents of subtasks found by specified saved filter
•issue in/not in subtaskIssuesFromFilter ("filter name or its id")- finds all parents of subtasks found by specified saved filter
•issue in/not in parentIssuesFromQuery("JQL query") - finds all parents of subtasks found by specified specified query
•issue in/not in subtaskIssuesFromQuery("JQL query") - finds all parents of subtasks found by specified specified query

[Norman Abramovitz]

Just checked to see what issues this plugin might have open and it looks like it is being upgraded to support 5.X and claims to being released today.

[Norman Abramovitz]

I noticed that the craftforge plugin is now uploaded to the support Jira 5.X now.