Can't rank backlog items with multi-criteria Order By in filter query

[Carlton Brumbelow]

I'm to the point of assuming it's not possible, but I would like to display my teams issues ordered by epic link on their Kanban board, so I added the following to my filter query:

ORDER BY "Epic Link", Rank ASC 

This actually works well, until we try to rank issues on the back log, at which point we get the following:

We don't want to use Epics as swimlanes, because it still shows epics that only have issues in the Done column, which we don't care to see.

Anyone have any thoughts on how to either get the ranking working with a multi-criteria Order By, or how to exclude Epics from swimlane configuration if there are only Done items in said Epics?

[Earl McCutcheon · Accepted solution]

Hi Carlton,

The filter ORDER BY clause must be "ORDER BY Rank ASC" to Enable Ranking, and it does not support multi-criteria sorting, as this is adding a non rank order option in place, and when using any option other than rank the sort order. 

For clearing up the displayed content for the epics as a swimlane, your option here is that you can collapse the Epic's where all the issues in the epic are all done using the arrow next to the Epic's name in the swimlane header here:

Regards,
Earl

[Carlton Brumbelow]

Hi Earl,

Thanks for the response. It's the answer I expected to hear, but I was hoping to find out a secret I wasn't aware of.

Thanks again,

Carlton