Forums

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

Nested Jira Sorting to group sub-task and by updated

Deleted user
July 1, 2019

Here is the JQL

project = "Security Incidents" AND status was in (Triage) during ("2019/06/05 13:59","2019/06/05 14:00") OR (issueFunction in subtasksOf("project = SI AND status = Triage") AND NOT created >= "2019/06/05 14:00") ORDER BY Rank ASC, updated ASC

What we want:

We want to have the oldest tickets at the top, and make sure the sub-task is listed under the parent.

What is happening:

The sub-task is being ordered under the parent, but is not being ordered by updated.

If you switch to ORDER BY updated ASC, Rank ASC the oldest does show, but the sub-task is no longer grouped with the parent because they can be created at different times.

The problem is:

"Rank" is the only field I found that groups the sub-task with its parent.

The question is:

Do you know of any way to order these so that the sub-task so that it stays with the parent and the tickets are ordered so that the parents are then ordered by "updated"?

1 answer

0 votes
achiffy
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
December 10, 2020

This really needs to be added. A simple GROUP BY would do the trick rather than being locked into Rank as your only order

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events