Assignee does not equal reporter

[Keith Cooper]

Hi all, 

Am I right in thinking that without an additional plu-in I can't create a filter or JQL thingy that will give me a list of all tasks where the reporter and assignee are different? 

Cheers

[Mayur Jadhav · Accepted solution]

Hi @Keith Cooper 

Welcome to the Atlassian community!!

Yes, It's not possible without plugins.

For example Script Runner has the expression function, which allows you to do:

issue function in expression("project = XYZ", "assignee != reporter")

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

Regards,
Mayur

[Nic Brough -Adaptavist- · Accepted solution]

Correct.  I find two things frustrating about JQL 

1.  Atlassian rarely make it clear that it is not SQL, and all JQL does is find issues that match criteria.  It does not display or report on them, it's just a list of issues for something else to look at

2.  There's no "field 1" = "field 2" function in it

So, yes, as point 2 is what you need here, you will need to look to marketplace apps to add functions that can do it.

[Bill Sheboy]

Hi @Keith Cooper -- Welcome to the Atlassian Community!

Yes, and...to the responses from Nic and Mayur: How often do you need to perform this comparison and for how many issues?

• Often and/or lots of issues: investigate marketplace app solutions
• Not often and up to 1000 issues: consider exporting the issues from and advanced search query and perform the user comparison in a spreadsheet
• Often, and with up to 100 issues: build an automation rule as this can perform field comparisons not possible with out-of-the-box JQL

Kind regards,
Bill

[Keith Cooper]

Every month or so. Number of issues vary. I'm spreadsheeting it at the moment, I was just hoping for a simple dashboard/widget solution using a filter. 

[Daniel Turczanski - JQL Search Extensions]

Hi @Keith Cooper ,

With standard JQL, you can only get a list of issues with links and export them to Excel for further processing. This works if you want to do a one-off analysis.

Standard JQL doesn't easily allow it, but you can find the results quickly using our professional indexing service JQL Search Extensions

After you install the app, you can simply search:

hasSameAssigneeAndReporter = "false"

Check the documentation for more information.

I hope this helps!
Daniel