How can I find the number of working days a ticket has been in its current status

[Jamie Helm]

Hi,

I have been trying to find a way to display the number of working days that a ticket has been in its current status on a filter - e.g. ticket 1 is currently in New status and has been in New for 4 working days, ticket 2 is in Resolved and has been for 10 days.

I have been trying with JQL but cannot find a way to calculate the days since status change - only the total open time as a column on the filter results. I did a bit of reading on similar tickets, which would seem to indicate this is not possible with JQL alone. Any help or suggestions appreciated.

Thanks!

[Jobin Kuruvilla [Adaptavist] · Accepted solution]

Create a filter like this (with approrpiate number of days):

status changed after -10d

You can save the filter and use it another query.

issue not in filter_saved_earlier

[Jamie Helm]

Thanks - it took a few filters but its a great roundabout solution.