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())
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.