Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

JIRA Searching with Sub-Tasks

Neil Taylor
Contributor
January 28, 2013

Hello All,

Is there a way to do a JIRA filter such that all sub-tasks for a parent ticket are shown after the parent, even if they are not in sequence number order?

Thanks!!!

2 answers

1 accepted

1 vote
Answer accepted
Bhushan Nagaraj
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
January 28, 2013

Hey Neil,

As far as I know the closest you can get is by using the JQL Tricks plugin

http://www.j-tricks.com/jql-tricks-plugin.html

Neil Taylor
Contributor
February 3, 2013

Thanks! Worked out to be what I needed - helped with some other searching I needed to do as well!

0 votes
Peter Friberg
Contributor
December 15, 2013

Hello,

I had a similar requirement, and solved it with a Script Runner Calculated Field.

The "Parent Child" scripted field is implemented as below:

import com.atlassian.jira.issue.Issue

Issue myIssue = issue
String issueId = String.valueOf(myIssue.getId())
Issue parentIssue = null
String parentIssueId = ""
if (myIssue.isSubTask()) {
	parentIssue = myIssue.getParentObject()
	parentIssueId = String.valueOf(parentIssue.getId())
	return parentIssueId + "_" + issueId
}
else {
	return issueId
}

A reindex may be needed after implementation.

An example value of a regular issue is "167854", and some subtask of this get the values "167854_167585" and "167854_167589"

This search makes the subtasks appear directly after the parent:
project = [Project Key] ORDER BY "Parent Child" ASC

Suggest an answer

Log in or Sign up to answer
TAGS
atlassian, jira product discovery, jpd premium, product management, idea management, product discovery, jira premium, product planning, atlassian community, product development, roadmap planning, product prioritization, feature management

Introducing Jira Product Discovery Premium ✨

Jira Product Discovery Premium is now available! Get more visibility, control, and support to build products at scale.

Learn more
AUG Leaders

Atlassian Community Events