Jira Jql is not working as expected .

[Boopathi]

I am an employee from Business Solutions. One of our employees reported an issue where JQL is not working as expected.

The reported query is:

assignee = currentUser() AND status != Closed

However, this query is also returning Closed tickets.

To validate this, I tested the query by explicitly specifying the user:

assignee = <userId / email / username> AND status != Closed

I observed the same behavior, where Closed tickets were still being listed. A similar issue was also reported by another Scrum Master.

I reviewed the query for any syntax or logical errors but could not find any issues. Since the JQL itself appears to be correct, this seems to be a Jira-side behavior or configuration issue.

Kindly help us understand why Closed issues are still being returned and advise on how this can be resolved.

[Duc Thang TRAN]

Hello @sboopathi 

What does "where Closed tickets were still being listed" mean? Are other tickets with a green status (Done/Resolved etccc ) still showing?
If yes, you can use:

assignee = currentUser() AND statusCategory != Done

This will only show tickets with gray (To Do) or blue (In Progress) status

[Aron Gombas _Midori_]

First off, just try this search with the "user clause" removed:

status != Closed

 If the problem still persists, then the root cause is not related to the "user clause". It is rather likely that it will reproduce the problem, but at least you eliminated one "moving part".

[Dave Mathijs]

Hi @sboopathi welcome to the Atlassian Community Forums!

First of all, please make sure to check that work items in status 'Closed' all have a Resolution set.

Check the following knowledge base article for more info:

Best practices on using the "Resolution" field in Jira Cloud

[Staffan Redelius]

Hi @sboopathi and welcome to the community.

What result do you get if you add a paranthesis to the second clause?

assignee = currentUser() AND (status != Closed) 

 Best regards,
/Staffan