Sorting first order and second order sorting

Anthony Orifice
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!
April 30, 2024

For my structure board I want to sort by status and then by priority

status = "in progress" or status = blocked or status = "ready to work" or status = "To Do" OR status = done and resolutiondate >= -5d ORDER BY status ASC, priority ASC

This syntax does not give me an error but also does not give me the results I am expecting

The first order sort works by status but not the second order sort by priority

The two items with high priority should be sorted together per the second sort order

Capture.JPG

2 answers

0 votes
Stepan Kholodov _Tempo_
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.
May 2, 2024

Hello @Anthony Orifice 

It should be possible to apply two different sorting rules at the same time. You might need to reorder the two enabled sort transformations and move one before the other in the panel. The order of transformations can make a difference.

I hope it helps. If you need further assistance, please reach out to us at our support portal directly - we would need to take a look at your configuration in more details.

Best regards,
Stepan
Tempo (the Structure app vendor)

0 votes
Matt Parks
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.
May 1, 2024

Are you doing the sorts as part of a Quick Transformation? If so, can you send over a screenshot of that configuration?

If you always want the work items to be ordered in that manner, I would recommend setting it as part of the JQL query that populates the Structure.

Suggest an answer

Log in or Sign up to answer