How can i make filter to see change of assignee from X to Y?

Question

Hello everyone!

I'm trying to make report about JIRA tickets made by user X but he changed assignee to me when issue was done, so now i'm trying to make a filter to see needed issues.

I need something like this:

assignee changed FROM 'userX' TO 'userY' and duedate >= 2016-06-01

Need your advice.

BR.

Contact Kintosoft · Answer

Your JQL query is fine so what is the problem?

reporter = Z and assignee changed from X to Y and duedate >=2016-06-01

I would review your data as it is probable that you think that the issue was not reassigned in that way but it really did.

if you need to get the history of changes from any issue, SQL for JIRA can help to visualize it in a straightforward way

alexander_dadaev · Answer

assignee was X AND assignee changed to Y and duedate >= 2016-06-01

Tarun Sapra · Answer

Did you use the ""assignee was" condition? for the previous user?