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 with different status arguments

Amvrosios Gogos

Hello team,

I am trying to create a JQL query that will return the tickets of an assignee in a specific project that are not finished (meaning that their status is not "DONE" or "RESOLVED")

Tried some different query versions with this one getting me closer to what I need:

project = "Customer service desk" and assignee = XXXXXXX AND (status != Done OR status != Resolved)

But is not filtering the Done or Resolved tickets, it just returns everything from the particular assignee.

Interesting enough, when I remove the parentheses the filter does not work at all (!) and returns tickets from other users and other projects.

Any help would be appreciated!

Thank you

Accepted answers

Amvrosios Gogos

After some testing it seems that the correct syntax is something like this:

project = "Customer service desk" and assignee = XXXXXXXAND status in (Approved, "AWAITING APPROVAL", Open, "PENDING IMPLEMENTATION", Reopened)

All comments

John Funk

Hi Amvrosios - Welcome to the Atlassian Community!

Just try this: project = "Customer service desk" and assignee = XXXXXXX AND statusCategory != Done

Amvrosios Gogos

Hello @John Funk !

Thank you for your time and effort to address my question

The thing is that using:

project = "Customer service desk" and assignee = XXXXXXX AND statusCategory != Done

It returns also the tickets with status "Resolved" which is also tickets I want filtered

Maybe I have a syntax error on my code, the general idea is that I don't want tickets with status Done or Resolved

Is there anything else you could recommend ?

Thank you,

Amvrosios

John Funk

Why are tickets being marked resolved that are not in a Done status category? What status are they in?

Amvrosios Gogos

Their status is "resolved"

Is a custom status that we have created. Is that relevant to the query?

Thank you,

Amvrosios

Amvrosios Gogos

After some testing it seems that the correct syntax is something like this:

project = "Customer service desk" and assignee = XXXXXXXAND status in (Approved, "AWAITING APPROVAL", Open, "PENDING IMPLEMENTATION", Reopened)

John Funk

This is a work around if you do not have the resolution status as a Done category status. Why are you not doing that?

Welcome!

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

Quick Links

Find more posts tagged with

jira

cloud

jira-cloud