JQL CHANGED is ignoring last change in status

Piotr Baranowski_fa7yau

i.e. I am executing this query.

created < "2022/03/01" AND status CHANGED TO "DONE" ORDER BY created DESC

And it doesn't show all issues that currently have "DONE" status. Only issues that had briefly "DONE" status and have been reopened. I have the same issue with WAS operator.

How to fix this?

Fabio Racobaldo _Catworkx_

Hi @Piotr Baranowski ,

Welcome to the Atlassian commmunity!

what is you desiderata?

If you need to have a list of all issues now closed, created in the past months, you can use the following query :

created < "2022/03/01" AND status = "DONE" ORDER BY created DESC

If you need to have a list of all issues closed or that were transitioned from DONE in the past months you can use the following query :

created < "2022/03/01" AND (status = "DONE" OR status WAS "DONE") ORDER BY created DESC

Hope this helps,

Fabio