Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

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

9 answers

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!

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!

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

1 vote
Muhammad Ramzan Community Leader Oct 10, 2019

 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

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

thanks for this one 

0 votes

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
Community showcase
Published in Jira

Do you use Jira Cloud with Microsoft Teams?

Hi, Jira users! Do you use Jira alongside Microsoft Teams? We want to hear how you’ve used the power of Jira Cloud and Microsoft Teams (via the Jira Cloud for Microsoft Teams app) to achieve a team...

470 views 3 7
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you