JIRA JQL: how to filter issues that changed assignee X or more days ago?

unknown

I'm trying to make a filter to see any issues that has been in a user queue for 7 days or more. I used the last updated date, but as this is not perfect as any updates to the issue changes this date. I want a filter to display any issue where the assignee was set 7 days (or more) ago.

Any help appriciated!

What I currently use:

Assignee in (user1, user2, user3) AND updated <= startOfDay(-6) AND status not in (Closed, resolved) AND issuetype in (Improvement, Bug)

Diego Zarpelon

Hey Jjohansen.

I think you can use an JQL like this:

assignee=currentuser() AND assignee changed after startOfDay(-7)

Just note that I usent the value currentuser() in my query, in your case you can use something like assignee in (value1,value2,value4)

Also this query will list all the user issues without filtering by status you can add it if you want.

Hope this helps!