Create a search of issue updated by the reporter

Question

Dear,

We want to create a view in our dashboard to show the tickets updated by the reporter. To enable this we have created a field called Updated by, so we can see who performed the last update on the ticket. Then we tried to perform an issue search where the reporter equals the Updated By field so we can create a view or alert when an ticket gets updated by a user.

In the Basic JQL it didn't work and with scriptrunner we didn't manage to make it work

Can some help with this issue or porpose an alternative solution?

Nic Brough -Adaptavist- · Answer

So the Scriptrunner JQL is not valid as JQL, I'm not sure what you might be thinking with that "expression" clause, it's not a function.  See https://scriptrunner.adaptavist.com/5.6.9/jira/tutorials/jql-functions-tutorial.html for some help with issueFunction usage.

Your "updated by" search is valid though, presumably because you have a field called "updated by" and a user potentially called "reporter"?

I think you might want to try the built-in updatedby() function, seen at https://confluence.atlassian.com/jirasoftwareserver/advanced-searching-functions-reference-939938746.html#Advancedsearching-functionsreference-approverupdatedBy()

Steve Vandeperre · Answer

With Scriptrunner see here the error message:

In JQL it doesn't give any results altough there are several ticket where the reporter equals the updated by

Nic Brough -Adaptavist- · Answer

Could you explain "in JQL it didn't work"?  What were you doing, what happened that broke it?

Same question for "with scriptrunner"