JIRA Searching with Sub-Tasks

Neil Taylor 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 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 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