reporter ≠ assignee

[Pavel Lyko]

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_]

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()

[Pavel Lyko]

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_]

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

A potential workaround could be:

1. Export the data to Excel, containing these columns:
   1. issue key
   2. reporter
   3. assignee
2. Add a formula to the fourth column which returns true if the reporter column is not equal to the assignee column.
3. Filter your spreadsheet to those rows where the formula evaluates to TRUE.

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