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

Question

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"

Sylvain BURGER · Answer

Hello,

Thank you for your time.

I checked... all our projects à Company-managed.

I tried to use the statusID rather than the name, but it don't solve my problem.

Trudy P Claspill · Answer

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.

Sylvain BURGER · Answer

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 ?