How do i create a JQL query where assignee is the same as reporter

Question

I am trying to build a complex query for my project where i need to identify when the ticket was moved back to reporter for missing information. The status for the ticket would move from NEW --> Missing Information and assignee would be the person who filed the ticket. An example query (which did not work for me) is

"project = "Change Request" AND "To Be Fixed Version" in ("2019.1 [2019.1]", "2019.2 [2019.2]", "2020.1 [2020.1]") AND status changed from NEW to MI assignee was in reporter

Brant Schroeder · Answer

It's not possible without plugins. For example Script Runner has the expression function, which allows you to do:

issuefunction in expression("project = FOO", "assignee = reporter")

The first expression is a filter query which you could leave as en empty string to run "assignee = reporter" on every issue.

Jack Brickey · Answer

you would need an addon for that, e.g. Scriptrunner. I beleive it has an expression function that would allow something like "assignee = reporter"