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 syntax question

Marcus Toepper

Hi all!

I am currently doing an automated mail reminder if collegues do have mulitples stories in progress. For that my automation uses a JQL, but I have a problem, my query also hits the field for additional assignees, therefore, I get to many results for the indiviual user as I only one those the colleague is the actual assignee.

In my mind, I should be able to formulate like:

asignee = xxx AND "additional assignees" NOT IN (xxx)

But this gives no results at all.

additional" assignees IN (xxx)

on its own however works. Seems, I am missing something here 8(

Any pointers in the right direction would be much appreciated!

Kind regards,

Marcus

Accepted answers

Tuncay Senturk _Snapbytes_

Hi @Marcus Toepper

Is your “Additional Assignees” field a native multi-user picker field?

If it is, then the JQL seems OK. Make sure that after running the below JQL;

"additional assignees" NOT IN (xxx)

there are issues which have assignee field value of xxx.

All comments

Tuncay Senturk _Snapbytes_

Hi @Marcus Toepper

Is your “Additional Assignees” field a native multi-user picker field?

If it is, then the JQL seems OK. Make sure that after running the below JQL;

"additional assignees" NOT IN (xxx)

there are issues which have assignee field value of xxx.

Dick

Do a lookupissues = for the different (parts of) JQL's you are using and list these in the automation log. It would reveal to you why you aren't seeing the right issues in the end.

- People that use logging are perceptive of the fact that sometimes other people would need to look into their automations and actually understand them. -

Be one of them.

Kind regards,
Dick

Marcus Toepper

Hi there!

Still don't get it.


project =BBBB AND issuetype = Story AND status="In Progress" AND (assignee = 11111 OR "Weitere Bearbeiter" IN (11111))

works like expected.


project = BBBB AND issuetype = Story AND status="In Progress" AND (assignee = 11111 AND "Weitere Bearbeiter" NOT IN (11111))

however does not. Is it me?

Tuncay Senturk _Snapbytes_

Hey @Marcus Toepper

The JQLs do not represent the same thing.

(assignee = 11111 OR "Weitere Bearbeiter" IN (11111))

returns if the assignee is 11111 regardless of the "Weitere Bearbeiter" field's value because you're using OR and it is TRUE when either is true.

However

(assignee = 11111 AND "Weitere Bearbeiter" NOT IN (11111))

means that assigneee MUST be 11111 AND the "Weitere Bearbeiter" MUST NOT be 11111.

I hope I was clear, please let me know if I am missing anything

Dick

Drawing a Venn diagram is also useful to get a grasp on how operators like not, or and and work.

Kind regards,
Dick

Marcus Toepper

Thanx for discussing this with me 8) I probalby should have written some more, but I tried to keep it brief in order to be not too tiresome

Long(er) version!

Given: I have one colleague, who is assignee in exactly one story and additional assignee in exactly one other story. So, expected result from query one (OR) is a count of two. Works.

If I shorten the statement to only query for the additional assignee (Weitere Bearbeiter) it also works, count is 1. This implies, that the two fields are distinct (of course)

Meaning: Both individual parts work. So the last statement should also yield a count of one -> The story, where the colleague is the actual assignee but not the one where he' just an " additional assignee" (NOT IN). But the count is still two.

Maybe I just struggle to understand it.

Welcome!

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

Quick Links

Find more posts tagged with

jira

jql

jira-data-center

data-center

jira-automation