I want to show a list of all sub tasks open and the related parent issue in a column.
project = XXX AND status = Open AND issuetype = Sub-task AND labels = XXX
How can I do it?
If you want to show the related parent issue, you should create a custom field, which would provide this information. Then you can add this field as a column in the Issue Navigator. You can create such a field with the Power Custom Fields add-on. It is a free add-on:
Or with ScriptRunner or any other plugin.
I don't believe there is any delivered functionality that will allow you to do this. You can use one of two plugins to accomplish this.
Scriptrunner or Craftforge Search Linked Issues for JIRA
More information can be found here about Craftforge - https://confluence.atlassian.com/jirakb/howto-filter-to-show-sub-tasks-of-a-filtered-list-of-parent-tasks-351109518.html
If you look at the scriptrunner option, I usually do it with a scripted field that does something like the pseudo-code of:
if (issue.issuetype in subtask-types)
return issue.getParentIssue().getKey() + " : " + issue.getKey()
This gives you a field that you can sort on by the parent ID and group all the sub-tasks with it. I usually go a bit further and drop them out as urls to the issues, but you can see where I;'m going.
Craftforge will do the same job for you without having to write any code.
The scriptrunner options works well with a scripted field like you suggested :).
In our case we just wanted to have the name of the parent of the subtask, not the keys.
Adding the script in case anyone has the same problem :
def log = Logger.getLogger("your.package")
//log.info("log something if you want");
//return null because we do not want the custom field to appear when there is no value
Don't forget to add "your.package" to the Logging and profiling : "configure logging level for another package".
Use searcher "none" for your field config to not needlessly add extra indexing.
Just add the new scripted field as a column of your query result page.
can get list of parent issues which are in To Do using JQL Search Extensions plugin
issue in parentOf(
"issueType = Bug"
) which gives us Find parents of subtasks with issue type = Bug.
issue in subtaskOf("status = Open") which gives us subtasks of parents with status = Open.
Catch up with Atlassian Product Managers in our 2020 Demo Den round-up! From Advanced Roadmaps to Code in Jira to Next-Gen Workflows, check out the videos below to help up-level your work in the new ...
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