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

need help with my JQL query

Robin DiNunzio

(assignee = robind AND status not in (Closed, Received, Reviewing, "In Committee")) OR (assignee = robind AND labels not in (PSG, Triage))

I'm still getting tickets that have the labels indicated above.

Thanks.

Accepted answers

All comments

unknown

Why do you have to specify "assignee = robind twice"? Just use:

assignee = robind AND status not in (Closed, Received, Reviewing, "In Committee")) AND labels not in (PSG, Triage)

Mala Benn

I think you're missing brackets, try adding some to the whole query

Robin DiNunzio

This is not working either, unfortunately. Maybe if I explain in non query language what I'm trying to do, a proper query can be written by someone who knows what to do. smile

I want to see two types of tickets:

Tickets assigned to me that have a project type of business analysis and the status is not in closed, received, reviewing or in committee
Tickets assigned to me that have a project type of client support and labels do not contain PSG or Triage.

Robin DiNunzio

Also, if I try to query just on the second bullet assignee = robind and project = "Client Support" and labels not in (PSG, Triage) I don't get the proper results. There's something about this second part that I can't get right.

Nic Brough -Adaptavist-

Best to break these down and build the query from component (Note that "project type" isn't a lot of use here, I've assumed you mean "issue type"

Tickets assigned to me
- assignee = robind

have a project type of business analysis and the status is not in closed, received, reviewing or in committee
- issuetype = "business analysis" and status not in (Closed, Received, Reviewing, "In Committee")
have a project type of client support and labels do not contain PSG or Triage.
- issuetype = "client support" and labels not in (PSG, Triage)

To combine them back together, use lots of braces to force the correct reading:

assignee = robind and (

( issuetype = "business analysis" and status not in (Closed, Received, Reviewing, "In Committee") )

( issuetype = "client support" and labels not in (PSG, Triage) )

)

If that doesn't work, then you need to do some debugging on what is going wrong - what issues are missing when they should be selected, and what are left out when they should be there?

unknown

There are some discussions here about the "Labels" part https://confluence.atlassian.com/display/JIRA/Advanced+Searching Searching labels is yes, a bit tricky.

Udo Brand

Nic is close, if you try to exclude labels you need also to include empty labels.So the part ( issuetype = "client support" and labels not in (PSG, Triage) ) should be ( issuetype = "client support" and (labels not in (PSG, Triage) or labels is empty) )

Nic Brough -Adaptavist-

Yes, sorry, I'm very fuzzy on searching labels because I tend to use labels in a really simple way. When I'm searching labels, the clause is almost always "label = x", and I forget that searching for negative labels is possible.