Order by Resolutiondate filter not working

[Susanna Brown]

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?

[Peter Bengov]

Hi @Susanna Brown are you using the Issues section to show the results (just a filter) or a board? Moving manually to the top sounds like you are in Board which might be using Ranking which overrides your ORDER BY clause. 

A screenshot will help, if you can supply one. 

[Susanna Brown]

I'm on a board. How can I have resolution date be the primary sort (so if it has a resolution date it sorts by that ie the Done column) and then have rank be the secondary sort so I can still drag and drop things that don't have resolution dates yet?

[Susanna Brown]

Playing around with it a little more, I figured out how to turn off the global sort by rank, but then it turns off dragability for all columns, even those that don't have a resolutiondate. How do I modify the board filter so that it will have a primary sort of resolution_date and a secondary sort by rank?

I've tried `(resolutiondate = null or resolutiondate >= -30d) ORDER BY resolutiondate DESC, rank ASC` as the board filter, do I need to make that a project level filter?

[Susanna Brown]

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.

[Susanna Brown]

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.

[Deleted user]

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.