You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
Next: Root
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
The Atlassian Community can help you and your team get more value out of Atlassian products and practices.
Hi,
Does anyone know how to write a JQL query to get all subtasks and linked issues to a Story/Task?
Regards
Monika
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!
Can you try
parent = "ISSUEKEY" OR issue in linkedIssues(ISSUEKEY)
Replace the issue key with the issue ID of your story or subtask.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I see the function available in the reference https://confluence.atlassian.com/jirasoftwareserver0713/advanced-searching-functions-reference-965542862.html#Advancedsearching-functionsreference-linkedIssueslinkedIssues()
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Is there an option to arbitrarily leave any ?
Ex: parent = "ISSUEKEY" that works with the key MAR-2 and for other occasions MAR-3
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
issueFunction in linkedIssuesOf("Key=JIRA-100") or issueFunction in subtasksOf("key=JIRA-100")
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thank you for all your answers. Parent in and linkedIssues was the solution for me.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
In Jira 8,
below works fine
Search Issues ==> Advanced ==> In the query field
parent = <ticket no>
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I used this query and it works :)
project = "ProjectName AND issuetype not in standardIssueTypes()
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
@Monika Brandström You could use a plugin like this one, it works for me!
Once installed, the query should be something similar to:
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
As far as i know there is no JQL in standard Jira for that. You need to get a Plug In.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.