How to write a JQL to search for a user in one field but not in another? Edited

[Fumida Ashraf]

I have 2 custom fields called "Code Review Approvers" and Code Review Approved By". When a workflow reached the "Code Review" status, a few users are selected to be the "Code Review Approvers". As a user approves, their name gets populated in the "Code Review Approved By" field.

I want to create a filter where the currentuser() is in "Code Review Approvers" but not in "COde Review Approved By", which means they have a pending approval.

The JQL I came up with was:

"Code Review Approvers" = currentUser() and "Code Review Approved By" != currentUser().

This, however, is not returning any issues. What am I doing wrong here?

[Кирилл Часовских]

Hi! you need to use "in" and "not in"

__

"Code Review Approvers" in (currentUser()) and "Code Review Approved By" not in (currentUser())

[Fumida Ashraf]

Hi, It still does not work.

[Kieran_Donnelly]

Did you ever find a solution to this issue?

[Payne]

I tried a small proof of concept, and it seems that the != portion of your query is what is failing. In my test "Test Multi User Field" = currentUser() returns the one issue that I expect, but "Test Multi User Field" != currentUser(), which I expect to return all other issues, returns 0 issues. I unfortunately have no guidance on this issue.