nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

JQL query if user exists in custom field don't display in search result

JBennett

Hi All,

I have a bit of a challenge with compiling JQL query to search on issues and scratching my head a little. Not even sure if it's possible as I've tried all the combinations.

Basically I have an "Assignee" field and "Additional Contributors" multi-user picker custom field. For the issue type when the "Assignee" or Additional Contributors" click a button to say they have completed their part, they automatically get added to another multi-user custom field labelled "Completed By".

In my JQL query filter I would like to show unresolved issues for the "Assignee and "Additional Contributors" but only if they do not exist in the "Completed by" field.

Can someone help me with the JQL logic to achieve this? Thanks.

Accepted answers

JBennett

@Tom Lister thanks for your help. I managed to get it working with the following:

("Completed By" not in (currentUser()) OR "Completed By" is EMPTY OR Reporter = currentUser()) AND (assignee in (currentUser()) OR "Additional Contributors" in (currentUser())

All comments

Tom Lister_fo1j4e

Hi @JBennett

try

(assignee in (<yourusernames>) or <your username> in “Additional Contributors”) and <your username> not in “Completed by”

JBennett

Thanks Tom. Didn't have any joy with that, I tried the following but it doesn't output the correct results.

(assignee in (currentUser()) or "Additional Contributors" in (currentUser())) and "Completed By" not in (currentUser())

JBennett

It works up until this point:

(assignee in (currentUser()) or "Additional Contributors" in (currentUser())) and resolution = Unresolved

It's the "Completed By" bit that's causing the headache with this query :-(

JBennett

Tried the following too but no joy :-(

(assignee in (currentUser()) AND "Completed By" not in (currentUser())) OR ("Additional Contributors" in (currentUser()) AND "Completed By" not in (currentUser()))

JBennett

@Tom Lister thanks for your help. I managed to get it working with the following:

("Completed By" not in (currentUser()) OR "Completed By" is EMPTY OR Reporter = currentUser()) AND (assignee in (currentUser()) OR "Additional Contributors" in (currentUser())

Parth Bharadiya

Not working for me. It says below error.

An option provided by the function 'currentUser' for the field 'Developer[Select List (multiple choices)]' does not exist.