Search code examples
jirajql

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

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.

Solution

  • 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