What's the correcect JQL query, to locate any pending tickets of Assignee, ie: Not with Done Status?

[Bhavini Shah]

What's the correcect JQL query, to locate any pending tickets of an Assignee, ie: Not with Done Status?

EG: Project = "XYZ" AND Assignee = "AB" AND Status != Done ORDER BY created ASC

[Rajesh · Accepted solution]

A better context on what you are trying to achieve will help give you better solution .

For now-
" Project = "XYZ" AND Assignee = "AB" AND Status not in (Done,Resolved,deffered,rejected,duplicate) ORDER BY created ASC "

Will give you all the tickets created from start of the project which is in the name of Assignee, to reduce the search result you may try adding Sprint or any other relevant condition in the query above. 

Also depending on workflow you can add more option in "Status not in " condition to achieve tickets which are not marked completed. 

[Stephen_Lugton]

Hi @Bhavini Shah 

The JQL query you've shown should work, but there are other options you can use:

This query will also filter out any rejected tickets, and will order them by when they're due:

project = "XYZ" AND assignee is "AB" AND statuscategory != Done ORDER BY duedate ASC

This query will only show tickets in certain statuses:

project = "XYZ" AND assignee is "AB" AND status IN (In Progress, To Do)

[Suraj Gurav]

You can use this query:

project = "XYZ" AND assignee is EMPTY AND status != Done

Update: Thank you Stephen for highlighting it. I read the question incorrectly, apologies for that. Your query will then solve the issue.

[Stephen_Lugton]

This will only show unassigned tasks @Suraj Gurav not assigned tickets as per the original question