JQL CHANGED is ignoring last change in status

[Piotr Baranowski]

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 _Herzum_ · Accepted solution]

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

[Piotr Baranowski]

Hi! My desired outcome would be to get all issues that had not status changed to done in given month

sth like

created < "2022/02/01" AND NOT status CHANGED TO "DONE" DURING ("2022/01/01","2022/02/01") ORDER BY created DESC

[Fabio Racobaldo _Herzum_]

Hi @Piotr Baranowski ,

your JQL should be correct. Unfortunately there's an open bug.

Please vote and watch it in order to keep updates https://jira.atlassian.com/browse/JRACLOUD-78540

Hope this helps,

Fabio