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

[Alexander Dadaev]

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.

[Pablo Beltran]

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

[Tarun Sapra]

You can use something like here - https://answers.atlassian.com/questions/316651 

and in combination with the above JQL in the answer link you can also use "assignee was" condition apart from 2 conditions given in answers

[Alexander Dadaev]

This worksm but not exactle that i wanted. This filter shows all issues assigned to X or Y, but i need issues assigned from X to Y only. Do you think can i add some exseptions in jql ?

[Tarun Sapra]

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

[Alexander Dadaev]

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