Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Celebration

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root

Avatar

1 badge earned

Collect

Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!

Challenges
Coins

Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.

Recognition
Ribbon

Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!

Leaderboard

Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,463,883
Community Members
 
Community Events
176
Community Groups

JQL query for filtering all subtasks of an issue

Hi,

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

 

Regards

Monika

10 answers

1 accepted

8 votes
Answer accepted

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!

11 votes

Can you try 

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

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

Both functions dont exist in standard Jira.

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

works in my parts, thanks a lot!

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

Like Jan Graeber likes this

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

Like Tytus Wachowski likes this

Worked for me, thank a lot @Nisha Hajamohideen 

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

thanks for this one 

Like Brandon Dulaney likes this

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

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

1 vote

 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

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.

In Jira 8, 

below works fine

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

parent = <ticket no>

I used this query and it works :)

project = "ProjectName AND issuetype not in standardIssueTypes()

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

Once installed, the query should be something similar to:

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

Suggest an answer

Log in or Sign up to answer
TAGS

Atlassian Community Events