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
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.
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)
This will only show unassigned tasks @Suraj Gurav not assigned tickets as per the original question
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.
It looks like you're new here. Sign in or register to get started.
