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?

[Ed Martinez]

Thanks for the confirmation Sash.

[Alex Medved _ConfiForms_]

Hi,

JIRA REST API uses the same port as JIRA itself. When you turn on the "Accept remote API calls" it does not open any news ports afaik, but enables the part in JIRA that accepts API calls

[Ed Martinez]

I may have just answered my question.  I spun up another instance and was able to get a response from the API. My other instance was on my mac, which isn't supported. :/