jql using status was in () ON "yyyy/mm/dd" not working

[Sylvain BURGER]

The query below returns too many results, including tickets that are in "closed" status since 2024.

status WAS IN ("En cours", "En cours de traitement", "_Réalisation en cours") ON "2026-02-01" AND "Groupe de résolution[Dropdown]" ="Dpt Solution / Domaine Développement"

[Trudy Claspill]

Hello @Sylvain BURGER 

Welcome to the Atlassian community.

If you want to exclude issues that are currently set to "closed" then add the following to your JQL:

AND status != Closed

[Sylvain BURGER]

Why does a ticket that :

* was in "open" status in January 2024,

* which changed to "closed" status in February 2024

* and has not changed since...

appear in the results of my query?

The ON "2026-02-01" shouldn't filter it ?

[Trudy Claspill]

Thank you for clarifying your dilemma.

From what type of Space is the inappropriate work item being retrieved? Click the ... next to the Space name, in the navigation panel on the left, for that work item. What do the last two lines in the pop-up say? It will be something like:

Software space
Company-managed

If it is a Team-managed project I found a KB stating that there is a known bug when using "status WAS" against such a project where the timeline is disregarded and all results are returned:

https://support.atlassian.com/jira/kb/in-a-team-managed-project-jql-is-not-working-if-it-contains-status-was-statusname/

The stated work-around is to use the Status ID rather than the Status Name in the query.