Order by Resolutiondate filter not working

Question

I'm trying to set up a kanban whose done column is sorted with the newly completed tasks at the top of the list. Those are the ones I'm most likely to need to reference, especially as the list starts to get long.

The filter I have set up is

`(resolutiondate = null or resolutiondate >= -30d) ORDER BY resolutiondate DESC`

The first part seems to be working, as manipulating the "= null" was successfully changing what I was seeing. However, the ORDER BY is not working at all. When I move new items to DONE, they appear at the bottom and do not move even if I refresh the page. In addition, I can manually move them to the top, which, if the sort was just backward, wouldn't be possible.

Any ideas why this isn't working?

unknown · Answer

Bit late to the party here, but I had similar issues when setting up structure (ALMworks) boards which were used for planning.

The answer is that it cannot be done, but for good reason. The rank sort means that everything is kept in harmony across the project so that if you move the priority of an issue on one board, its moved everywhere else.

The ability to move the priority of an issue up and down in the boards cannot be done if the issue is placed exactly where it is based on a formula. Essentially the only way to move an item sorted by resolutiondate is to update the value in the resolutiondate field.

What I think you'd prefer to see is an override filter that can be applied to an individual column, in this case your DONE column, such that you can view things that you don't care about the rank anymore as the rank is irrelevant when an issue is done and thus can be locked from moving but thats ok as its being viewed only not interacted with.

This would be a great addition to the column setting of the board, but alas I don't believe its possible at the moment.

Susanna Brown · Answer

Nope, it turns out that while it's correctly using rank as a secondary sort when I'm viewing the page (sorting all things with identical ie NULL resolution dates by rank) it's not allowing me to drag anything to a new rank position. It's giving me a toast that says "Ranking is disabled, as the Filter Query for this board is not ordered by ascending Rank. Please check your filter configuration."

But clearly it's recognizing that rank is being used as a secondary sort because it's displaying everything in the correct order that I set before this mess started.

Susanna Brown · Answer

Making it a project level filter made it work, I still don't understand why I can't use board filters to affect sort order, but since this board is the only way I view this project, it's fine for now.