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!
As far as i know there is no JQL in standard Jira for that. You need to get a Plug In.
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.
I see the function available in the reference https://confluence.atlassian.com/jirasoftwareserver0713/advanced-searching-functions-reference-965542862.html#Advancedsearching-functionsreference-linkedIssueslinkedIssues()
mhm ur right. I wonder why it doesnt work for my Instance then. . .
issueFunction in linkedIssuesOf("Key=JIRA-100") or issueFunction in subtasksOf("key=JIRA-100")
@Monika Brandström You could use a plugin like this one, it works for me!
Once installed, the query should be something similar to:
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
Thank you for all your answers. Parent in and linkedIssues was the solution for me.
thanks for this one
I used this query and it works
project = "ProjectName AND issuetype not in standardIssueTypes()
In Jira 8,
below works fine
Search Issues ==> Advanced ==> In the query field
parent = <ticket no>
This worked for me too! Thanks a $milli$!
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.
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.
It looks like you're new here. Sign in or register to get started.
