JQL Scripted Function to check if assignee = reporter?

[Brent Webster]

JQL query: "assignee = reporter" does not exist out of the box and of the questions asked about it in this forum, the answer is usually to buy the JQL Tricks plugin. Various Script Runner functionality has saved me from many Jira inadequacies but I'm getting fed up plugging the holes in dam here.

I'm hoping someone has written a JQL Scripted Function for this simple query.

Anyone?????? Or any other solution

[JamieA · Accepted solution]

What should work is:

issueFunction in expression("", "assignee != reporter")

(You can use the first param to provide a jql query that will restrict the issues that will be checked).

but I seem to have explicity prevented using those fields in the expression function, but I can't remember why.

I've changed the code and it seems to work fine - if you watch https://jamieechlin.atlassian.net/browse/GRV-310 you will get notified when it's released.

[Brent Webster]

Thanks Jamie, as of 2.1.11 ScriptRunner performs excellently-- super job!!!

[JamieA]

Great, thanks for letting me know.

[David Jansson]

Hi would it be possible to filter on issueFunction in expression("", "creator != reporter") to find issues where users have changed reporter?

[JamieA]

No it's not exposed, but it would be good if it was so I created: https://jamieechlin.atlassian.net/browse/GRV-642

[David Jansson]

Thanks, Will be looking forward to upcoming releases. Keep up the great job!

[Henning Tietgens]

I'm not into scripted JQL (yet :-)) but another idea is to create a Script Runner scripted field which checks if issue.reporter == issue.assignee and return 0 or 1. This scripted field could be checked in JQL...

[Brent Webster]

That's a possibility but I'm already working on another scripted field issue which you have commented on (i.e. https://answers.atlassian.com/questions/198927/scriptrunner-s-scripted-field-not-showing-up-in-issue-navigator). Not having much luck with scripted fields yet but I'm hopeful.