Is it possible to sort groups in jira structure?

[Leonard Chew]

I have a Structure with a Group by "Due Date" Button.
When activating the Group By "Due Date" Button, I would like to sort the groups by (due-)date descending.

Is that possible?

[Leonard Chew · Accepted solution]

I was able to solve this, but did not find any direct answer in the documentation, so I'll answer myself for all people who have the same problem :-)

When you group your issues, you can only group by aggregated values, and not by values on the issues themselves.
So even if your isues are sorted by due date, prior to the grouping, the groups themselves will NOT be sorted by due date.

You can create an aggregated value by using formula columns.
In my case, I have created the formula column "MaxDueDate", which is of type "date" (because we group by date, you could also use min or avg date, resulting in the same).

As soon as the new column is created, you can sort your Groups by this column 

Hope this helps!

See also
https://community.atlassian.com/t5/Jira-Core-Server-questions/How-can-I-sort-groups-by-max-dueDate-for-epics-in-this-groups/qaq-p/1001709

[Bert Dombrecht]

Thank you @Leonard Chew !

I was able to use your approach to Group by and then sort by Component.

IF (itemType = "component") :
itemid

[Heston Liebowitz]

This was very helpful. I did something similar to group issues by fix version and then sort the groups by release date.

MAX#strict { map(fixVersions, x -> x.releaseDate) }