Unassign all tickets that are closed, cancelled, done

[lindy]

I would like to find the correct query to search all Jira projects and find all tickets that are in a status of closed, done and cancelled and are still assigned to a person with the end result being that all these tickets become unassigned.

[Trudy Claspill · Accepted solution]

Regarding the person for whom you are searching in the Assignee field - is that person still an active and valid user in your JIRA instance? 

Typically you would search for tickets assigned to a particular person with 

assignee=<start typing the person's name>

But if that person is no longer a valid user, or inactive/disabled, of the instance then they will not come up when you start typing their name. 

But I concur with @Bill Sheboy in wondering why you would want to change the assignee for issues that are already closed?

[Bill Sheboy]

Hi @lindy 

I am curious about what problem you are trying to solve.

It would seem those issues in close, cancelled, and done were assigned to someone when they became "resolved".  Why unassign them later, essentially losing the history of who worked on them? Thanks!

Best regards,

Bill

[Vero Rivas]

Hi @lindy 

  Try this query

  Project is not EMPTY and status in (closed, done, canceled) and assignee is not EMPTY

  Another query maybe

  Project in (name of projects) and status in (closed, done, canceled) and assignee is not EMPTY

Cheers

[lindy]

Many thanks @Vero Rivas 

[Vero Rivas]

If you found the answer useful, could you please accept it? Many Thanks