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

[Kumar Aniket]

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?

[Walter Buggenhout]

Hi Danny,

No, there is not such a function. You might have found out yourself that you can search for any unreleased version (see included screenshot and the advanced search function reference), but that's about the closest you can get:

Screen Shot 2016-11-09 at 19.51.58.png