JQL query for filtering all subtasks of an issue

[Monika Brandström]

Hi,

Does anyone know how to write a JQL query to get all subtasks and linked issues to a Story/Task?

Regards

Monika

[Gustav L'Estrade · Accepted solution]

Hello @Monika Brandström

Below JQL-query worked for me, giving me all subtasks and linked issues to my AC-15 issue:

parent = AC-15 OR key in linkedIssues("AC-15")

What above query says: Fetch all issues that have AC-15 as a parent or whose key is linked with AC-15

How does it work for you?

Hope it helps and good luck!

[Nisha Hajamohideen]

Can you try 

parent = "ISSUEKEY" OR issue in linkedIssues(ISSUEKEY)

Replace the issue key with the issue ID of your story or subtask.

[GS1337]

Both functions dont exist in standard Jira.

[Nisha Hajamohideen]

I see the function available in the reference https://confluence.atlassian.com/jirasoftwareserver0713/advanced-searching-functions-reference-965542862.html#Advancedsearching-functionsreference-linkedIssueslinkedIssues()

[GS1337]

mhm ur right. I wonder why it doesnt work for my Instance then. . . 

[mochadwi]

works in my parts, thanks a lot!

[Oliver Emmler]

Hi @Nisha Hajamohideen ,

your solution works great for me in the standard cloud installation. Thanks. I have added an "order by rank" to show the order used in the issue view of jira.

parent = "DOC-9902" ORDER BY rank 

Best Regards,
Oliver

[Marcelo Cid (Antiguo)]

Is there an option to arbitrarily leave any ?
Ex: parent = "ISSUEKEY" that works with the key MAR-2 and for other occasions MAR-3

[lpoddaturi]

Worked for me, thank a lot @Nisha Hajamohideen 

[Mandeep Singh]

linked issues are different than subtask. how I will find all the subtasks for a story with linked issues?

[joseph weiss]

issueFunction in linkedIssuesOf("Key=JIRA-100") or issueFunction in subtasksOf("key=JIRA-100")

[Sayan Kaiser]

thanks for this one 

[Mister Dulaney]

This worked for me too! Thanks a $milli$!

[Sita Raghunadh Vedala]

You can try this in the JQL query search text box - 

issueFunction in subtasksOf("fixversion=37.0") 

You can give your required fix version or use any other filter.

[Monika Brandström]

Thank you for all your answers. Parent in and linkedIssues was the solution for me.

[Muhammad Ramzan_Atlassian Certified Master_]

 JQL Search Extensions for Jira & reports plugin have rich queries which are very useful. You can either use scriptrunner  or   JQL Search Extensions for Jira & reports plugin.

I am using  JQL Search Extensions for Jira & reports plugin and its really amazing.

Following query will be helpful in your case.

It will return all linked issues and sub tasks linked with JQL-3 or JQL-5

issue in linkedBy(JQL-3, JQL-5)

you can find more documentation here

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

[GS1337]

As far as i know there is no JQL in standard Jira for that. You need to get a Plug In. 

[Tad Foster]

issuekey in childIssuesOf("your parent issuekey-xxxx GOES HERE")

example: issuekey in childIssuesOf("NMER-9549") where NMER-9549 is the Story and the search results would be the subtasks.

[MSJ]

In Jira 8, 

below works fine

Search Issues ==> Advanced ==> In the query field

parent = <ticket no>

[Salonee Wong]

I used this query and it works :)

project = "ProjectName AND issuetype not in standardIssueTypes()

[Thomas B]

@Monika Brandström You could use a plugin like this one, it works for me!

• https://marketplace.atlassian.com/apps/31601/search-linked-issues?hosting=server&tab=overview

Once installed, the query should be something similar to:

• issue in parentIssuesFromQuery("project = PROJKEY AND issuetype = Sub-Task")
• See https://addonrock.atlassian.net/wiki/spaces/KB/pages/557163/JQL+Functions for all functions within this free app