jql query

[Loretta]

I am trying to get issues for a project that have child issues instead of bugs.  What do I need to do to get this?  I think it may be a jql query, but not sure and what the query would be.

[Jack Nolddor _Sweet Bananas_ · Accepted solution]

Hi,

Sadly you cannot achieve the desired search using standard features on Jira, you must go for a third-party app instead. If you are on Server/DetaCenter, using i.e. JQL Booster Pack you can type the following:

1) Search for issue on project 'MyProject' having subtasks:

project = MyProject AND issue IN hasSubtasks() 

(*) Note that this is just an example, you must tune above query to fit your needs.

Using this app you can also query other issues relations, check:

• epicsOf()
• hasSubtasks()
• issuesInEpics()
• linkedIssuesOf()
• parentsOf()
• portfolioChildOf()
• portfolioParentOf()
• subtasksOf()

References:

• Official documentation

Kind Regards

[Bill Sheboy · Accepted solution]

Hi @Loretta 

You cannot do this with out-of-the-box JIRA.  The closest you can get is to list the items and sort by the ones which have subtasks (you cannot search the subtasks field):

project = myproject ORDER BY subtasks

If you have any of the add-on marketplace scripting tools, you can build a query to do what you want.

Best regards,

Bill

[Ziad Bakhiet]

Hello Loretta,

You can get the result using JQL Search Extensions

You can search for issues that have subtasks with a particular issue type.

• JIRA Cloud: subtaskIssueType = "YourSubtaskName"
• JIRA Server: issue in subTaskType("YourSubtaskName")

There are many other functions related to subtasks like:

• SubtasksCount
• SubtaskSummary
• SubtaskKey
• SubtaskPriority
• SubtaskIssueType
• SubtaskStatus
• SubtaskStatusCategory

The full documentation can be found here.

Regards,

Ziad