TIckets where I reassigned to someone else

[Yatish Madhav]

Hi all

For triaging, I reassign many tickets to another user or other users. Is there a way / JQL, for me to filter these out and as bonus to filter these between a speific date?

Ie. i would like to find all tickets I (or potentially user X), reassigned tickets to user Y, and potentialy only reassigned them between dates A and B?

This would be helpful to see esp in case of service agents reassigning 'too much' or for analyzing our capacity management.

Thank you

Yatish

[Alex Koxaras -Relational- · Accepted solution]

Hi @Yatish Madhav 

You can use:

assignee was ASSIGNEE_ID DURING ("2023/01/01","2023/01/16")

Of course change the due dates to these that suit you. 

[Alex Koxaras -Relational-]

But of course the above JWL will yield issues that had assignee user X at some point in time.

[Yatish Madhav]

Thanks @Alex Koxaras -Relational-  - that does not seem to work for me. I applied that JQL and got 1000+ tickets for a user I assigned a few tickets to and I see many tickets that were last updated last year even though I put in 

assignee was xxx DURING ("2023/01/13","2023/01/16")

[Alex Koxaras -Relational-]

That would happen because "was" will return issues that still have or had assignee X. From a search I've made I think that you can't search for issues that changed assignee to another user

https://community.atlassian.com/t5/Jira-questions/How-do-I-Ask-if-the-assignee-changed-to-unassigned-during/qaq-p/930108

You can perform however the following:

assignee CHANGED during ("2023/01/13","2023/01/16")

Which will yield all issue that changed assignee during that period.

[Yatish Madhav]

That is interesting ... Thanks for that.

I got this to work

assignee was 5ea71314ddd45f0b94ec371f DURING ("2023/01/13","2023/01/16") and assignee CHANGED during ("2023/01/13","2023/01/16") and assignee = 5ea71314ddd45f0b94ec371f

Now I just want to know something like 'assignee CHANGED by userYYY' ... any idea, please?

[Alex Koxaras -Relational-]

Try "changed BY" followed by the user id and not the username e.g.:

assignee changed by 5ea71314ddd45f0b94ec371f

[Yatish Madhav]

Brilliant! Thanks @Alex Koxaras -Relational-  - each of your answers proved to help me! Kudos to you! Appreciate the help.

[Alex Koxaras -Relational-]

@Yatish Madhav kindly mark my answer as accepted, in order to help others find proper answers to similar questions. Thank you!