reporter ≠ assignee

Question

Hello
how to write a query that limits my search so that it does not display tickets where the submitter is also the resolver?
something like
reporter ≠ assignee

Aron Gombas _Midori_ · Answer

Yes, I understand the problem, I'm just saying that it cannot be solved in plain JQL.

A potential workaround could be:

* Export the data to Excel, containing these columns:* issue key
* reporter
* assignee

* Add a formula to the fourth column which returns true if the reporter column is not equal to the assignee column.
* Filter your spreadsheet to those rows where the formula evaluates to TRUE.

Now you have the key of the corresponding issue, voila!

Pavel Lyko_44csv9 · Answer

Thanks, but unfortunately it's not enough.
I have a filter whose result displays tasks from department of 25 people.
So the resoult would be displayed OK only for "current user", but to all other it wouldnt...

Aron Gombas _Midori_ · Answer

You can't use two fields on the two sides of the "!=" (not equal) operator, unfortunately.

You can only compare the "reporter" against a user literal or a JQL function:

reporter != joe

reporter != currentUser()