Jira filtres - checking the time spent in multiple status

[Maxime Grosdoigt]

Hello, 

I would like to create a report to easily see if a ticket has spent more than 7 days in the same status. 

This is my current search: 

Project = CANDIDATE AND issuetype = Candidate AND NOT status changed AFTER -1w AND status in (Introduction, "Introduction feedback", Offering, Screening, "Screening feedback", "skills assessment", "Skills assessment feedback", Sourcing) ORDER BY created DESC

Context: 

- I have 10 different statuses on my board. 

- I already tried "statusCategoryChangedDate" but it's not answering my need since I am not talking about categories here :) 

- I have checked in a similar post an answer about:

AND NOT status changed AFTER -1w

But I still can't make it work.

My current Workflow:Thanks!

[Trudy Claspill]

Hello @Maxime Grosdoigt 

Are you trying to find issues that have spent more than 7 days in any status ever, or issues that have spent more than 7 days in their current status?

[Maxime Grosdoigt]

Thanks for this question @Trudy Claspill 😀

Second option, I need to see the issues that have spent more than 7 days on their current status.

[Trudy Claspill]

I see that you have a criteria for "status in..." that lists all your statuses that are part of the "In Progress" Status Category. You could simplify your filter by changing that to 

statusCategory = "In Progress"

Using 

AND not Status changed -1w

should give you all the issues that have not changed status in the past 7 days.

Can you try simplifying your query to perhaps filter based on only one status (i.e. Introduction) to reduce the results data set? And can you tell us more about how the results you are getting don't match your expectations?