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

[Amvrosios Gogos · Accepted solution]

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?

[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

[John Funk]

That's okay as long as the Resolved status is a Done category status.