Find all tasks that contain subtasks inside using JQL

[Ivan Mantrov]

It doesn't matter what values the fields have. I am interested in the fact of the existence of a subtask inside.

[Ivan Mantrov · Accepted solution]

It seems there are no special operators in JQL for such cases but I've found the solution:

using obviously non-existent task names in combination with issueFunction in parentsOf()

like this issueFunction in parentsOf("issue != BLABLA-100")

It works! And if you wanna get issues without subtasks you can put NOT before the request described above

[Sagar Mahajan]

Hi @Ivan Mantrov 

By default it's not possible to get the list of all sub-tasks for the parent issue, you will need a third party for the same like Script runner or JQL Search Extensions for Jira - the JQL extensions which provides the JQL functions to achieve this

Documentation links

https://scriptrunner.adaptavist.com/5.6.9/jira/jql-functions.html#_subtasks

https://jqlsearchextensions.atlassian.net/wiki/spaces/SEARCH/pages/30497099/JQL+Search+Extensions+Server#JQLReference(Server)-SubTaskStatus