Query on creator vs reportor

[Cailin Che]

Hi all!

We have a couple of users who are frequently put into the system as the reporter of issues so that questions and clarifications come to them, but they didn't create the issue and sometimes have to backtrack to find the creator for follow-up.

Is there a way to query Jira to find all issues where the creator is not the same as the reporter? We have Scriptrunner, if that helps! This would allow us to display creator and reporter on the issue navigation list for quick review instead of digging through months of history on the issue.

Thanks so much!

[Ste Wright · Accepted solution]

Hi @Cailin Che 

You should be able to use the expression JQL function in Scriptrunner - https://docs.adaptavist.com/sr4js/latest/features/jql-functions/included-jql-functions/calculations#expression

For example, the JQL might look like this (you'll need to test it):

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

Ste

[Cailin Che]

That worked, thanks so much!

[Cedric Weber]

Hi @Ste Wright , this worked on Data Center. Is there also a known solution for Jira Cloud? My use case is to create a report on how many issues are actually created by Service Desk Team on behalf of a customer (e.g. during a Phone Call). 

[Wouter Huyghe]

If your Service Desk Team share a specific Jira group that can identify them, you can query for tickets created by the members of that group:

creator IN membersOf("<name of the Jira group>")

You can of course narrow things down by date, project, etc.

[Cedric Weber]

@Wouter Huyghe yes, sure this can help a little bit, but in our case with a huge IT Service Desk there are also a lot of requests by the Service Desk Team in the role of customers - which then will be removed. So IMHO the best way to find a request that a Service Desk Team member created for an other customer is to check creator vs. reporter... 

[Wouter Huyghe]

If you wish to filter out the requests they created by a Service Desk agent in his role as a customer, you can do this:

creator IN membersOf("<name of the Jira group>") AND reporter not in membersOf("<name of the Jira group>")

Note that if you check for "creator does not equal reporter", you would still get requests logged by one Service Desk agent for another agent.

[Cedric Weber]

@Wouter Huyghe yes! Thank you, this fixes 99.5% of the cases and is good for my use case!

Note that if you check for "creator does not equal reporter", you would still get requests logged by one Service Desk agent for another agent. 

Yes, this happens with your suggested query but not with the original query mentioned above.