Sorting first order and second order sorting

Question

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

Stepan Kholodov · Answer

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)

Matt Parks · Answer

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.