nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Query on creator vs reportor

Cailin Che_3cob1c

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!

Accepted answers

Ste Wright

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

All comments

Ste Wright

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_3cob1c

That worked, thanks so much!

Cedric

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.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

scriptrunner

jira

jql

jira-data-center

data-center