How to filter resolved tasks that were "In Progress" and assigned to the current user

Question

I'm looking to make a JIRA filter to get a list of resolved tasks that I have worked on.

Currently I have the following:

resolution = Fixed AND assignee was currentUser() AND status was "In Progress" ORDER BY resolutiondate DESC

But really I'm looking to only see tasks that were "In Progress" while I was assigned to it.

The above picks up too much, any resolved task that went through development that I may have been assigned to during any status.

I'm thinking perhaps I can pull out a date range for the "In Progress" status somehow, but I'd hope there'd be something more simple.

---

edit – The user that most often changes the status to "In Progress" is a bot. So AND status CHANGED TO "In Progress" BY currentUser() wouldn't work most of the time.

Answer 1

I was faced with the same problem and concluded that it is impossible until will be done "Updated by" search filter. Now all filters works separately (assignee, updated, created and etc). Each filter considers only its own conditions. I wrote a script with jira api to use it to check all conditions.

Answer 2

So we've worked it out for future issues by adding a new field we've called Resolver.

We're populating it with the assigned user when an issue is moved to the "In Progress" status.

The JQL I now have is:

resolution = Fixed AND (assignee was currentUser() AND status was "In Progress" OR Resolver = currentUser()) ORDER BY resolutiondate DESC`

Or if you don't mind missing out on old issues:

resolution = Fixed AND Resolver = currentUser() ORDER BY resolutiondate DESC