The "order by" clause in JQLs respects the sorting of "group by" fields as well. This means that groups created by the "group by" fields in the JQL section can be ordered in the desired sequence. Additionally, you can now choose where to place orphan elements of the respective "group by" field. This update provides greater flexibility and control over the organization of your data.
How to sort ‘group-by’ fields in a JQL section
Here is an example:
There is JQL section with ‘Components’ field as a group-by field.
So the Jira issue data returned by this JQL section will be grouped by the value of their component.
If you want those groups to appear in a certain order (ascending or descending) , then you should include the group-by field (Components field in this case) in the ‘Order by’ clause of the JQL like this
This will automatically order the groups created by the ‘group-by’ field in the order defined in the JQL.
You can include multiple fields in the order by clause of the JQL and the order of all such fields will be honored in the output of that JQL section.
Orphan elements
Now if there are any Jira issues where the value of the ‘Components’ field is blank, such issues are called orphans.
By default, the orphan issues are placed at the bottom of the group.
However, you can choose to place them at the top of the group.
Navigate to the field customization menu of the concerned group-by field to choose where the orphan issues should be placed.
