How to order issues by "Days in status"?

Ian Liu Rodrigues_5adp6x

I'm trying to setup my Kanban view, and this is my board's filter query:

project = PDR
and status not in (CANCELADO, Backlog)
and (
  status != Concluido
  or (status = Concluido and updatedDate >= startOfDay(-1))
) ORDER BY priority

 I would also like to order by the number of "Days in status". Is this possible? I couldn't find a field with that value. Something like

) ORDER BY priority, daysInStatus

Bill Sheboy

Hi @Ian Liu Rodrigues 

There is no built-in "days in status" field.  It is dynamically calculated when shown in the UX for the board.

And, when the sort order for the board filter is changed, this disables the ability to drag-and-drop to reorder issues on the board and backlog.  Do you need that feature?  If so, please change your filter back to the default of ORDER BY Rank ASC

 

It appears you are trying to organize your Kanban board to show issues by Priority at the top of columns and emphasize the days in the column.  Have you instead tried...

• Use the swim lanes feature of boards, with JQL, to order into rows by Priority
• Enable the days in column feature
• Use the card color feature, with JQL, to perhaps add emphasis for issues in a status / column for longer than some threshold value

Kind regards,
Bill