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; } } }

filter syntax for currentUser() in a list field

Alexander Reum

Hi,

in my jira (7.6.1) I have a custom field called "Co-Assignees". It is a multi-user picker that an author can use for adding assistants to a task.

I'd like to define a filter that gets me all issues where the current user is either the assignee or a co-assignee. Unfortunately the following doesn't seem to work:

assignee = currentUser() OR currentUser() IN Co-Assignees ORDER BY priority DESC, updated DESC

It seems that the IN operator does not accept a function as left operand. Is that right or am I doing something wrong? Is there an alternative way?

Thanks in advance for your help.

Alex

Accepted answers

Kurt Klinner

@Alexander Reum

Hi Alex

did you try

assignee = currentUser() or <CUSTOMFIELD> in (currentUser())

assignee = currentUser() OR Co-Assignees in (currentUser()) ...

Cheers

Kurt

All comments

Kurt Klinner

@Alexander Reum

Hi Alex

did you try

assignee = currentUser() or <CUSTOMFIELD> in (currentUser())

assignee = currentUser() OR Co-Assignees in (currentUser()) ...

Cheers

Kurt

LarryBrock

I know it sounds slightly backward but I agree with @Kurt Klinner that this is the right syntax.

~~Larry Brock

Alexander Reum

Dear Kurt and Larry,

thank you for your help. It works perfectly. Actually I did try to swap the operands, because I saw it elsewhere, but it didn't work because I omitted the parentheses around currentUser().

So, if I interpret your solution right, we're making a 1-element list out of currentUser() and look for an intersection with Co-Assignees? Atlassian's JQL documentation should really mention that capability of the IN operator.

Alex

Kurt Klinner

@Alexander Reum

Glad that it worked :-)

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

filter