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

Question

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?

Fabian Schubert · Answer

Hi Bas!

I just found your addition to this and wanted to say "thanks", because it helped me to fix the jql I was fighting with for a while ;-)

Best regards

Fabian

Bas Roos · Answer

Not sure if this is still relevant for you, but else for anyone else who finds this:

When you test a multi-user field != currentUser(), it will not match if the mutli-user field is empty. You need to add this specifically to your query. The solution would be:

"Code Review Approvers" = currentUser() and ("Code Review Approved By" != currentUser() or "Code Review Approved By" is empty)

Kieran_Donnelly · Answer

Did you ever find a solution to this issue?