Filters. JQL doesn't work like it's supposed to

[Alex Zavodchikov]

Hello!

I created a special filter set up to show all tasks that are under "review" and have the current user assigned to the custom column "Reviewers". The request looks like this and perfectly works:

(project = XX or project = XXX) AND status = "Code Review" and Reviewers = currentUser() order by created DESC

I've created another field called "Approved" and tried to modify my JQL request to show only those tasks, which are not assigned by the same user to both columns ("Reviewers" and "Approved" at once". So this filter should show me the task when I'm assigned to the column "Reviewers" and not assigned to the column "Approved"

The request looks like this now: 

(project = XX or project = XXX) AND status = "Code Review" and Reviewers = currentUser() and Approved != currentUser() order by created DESC

I don't have a correct result (I have nothing in search results) if my task is in "Code Review", I'm assigned to the column "Reviewers" and the column "Approved" is completely empty.

Could you please advise me on the solution? Probably jira's bug...?

[Hana Kučerová · Accepted solution]

Hi @Alex Zavodchikov ,

welcome to the Atlassian Community!

Have you tried something like:

project in (XX, XXX) AND status = "Code Review" AND Reviewers = currentUser() AND (Approved is EMPTY OR Approved != currentUser()) ORDER BY created DESC