JQL searches for "status Changed From" and "status Changed To" aren't working

[Brandon Hite]

I've read multiple Atlassian posts and Stack Overflow posts, copying and pasting the exact searches as well as tweaking them a bit to fit our project keys and whatnot, and I cannot get this to work. For example, everything I've read suggests this search should return all issues where their status changed from the "QA" status to the "CLOSED" status since September 1, 2019:

`project = xxxxx AND status CHANGED FROM "QA" TO "CLOSED" during (2019-09-01, 2019-11-12)`

However, this repeatedly returns 0 results. I've manually found issues that have a line in their Activity log showing this status transition within that date range, so I'm not sure what I'm doing wrong. We're on Jira Cloud, using next-gen.

[Dario B]

Hi @Brandon Hite ,

You are facing the bug tracked in our system as:

• [JRACLOUD-72180] - JQL query search using "status was" returns incorrect unreliable results for next-gen projects

We also have a more generic bug ticket open for the same issue (not restricted to next-gen projects):

• [JRACLOUD-70797] JQL query search using "status" returns incorrect unreliable results 

Please vote for the above bug tickets and set yourself as a watcher so that you will be notified in case of any update/progress. The bugs will be addressed according to the Atlassian Cloud bug fixing policy.

Cheers,
Dario

[Nico]

Hi already voted for the two of bugs you mentioned Dario, but even I receive results for issues CHANGED FROM "To Be Verified" TO "Done" during a period of time (JQL pretty similar to the first post) I don't receive any results for Issues which status CHANGED FROM "To Be Verified" To "In Progress"

This query works:
project = XXX AND status CHANGED FROM "To Be Verified" TO "Done" DURING (2021-06-30,2021-08-04)

This query does not work:
project = XXX AND status CHANGED FROM "To Be Verified" TO "IN PROGRESS" DURING (2021-06-30,2021-08-04)

[Dario B]

Hi @Nico ,

Can you let us know whether you are using a Company or a Team managed project? 

Also, have you tried the workaround detailed in below community thread:

• https://community.atlassian.com/t5/Jira-Software-questions/BUG-JQL-Unable-to-query-next-gen-project-s-issues-with-status/qaq-p/1319216#M67818

[Nico]

Hi Dario, sorry for the late response. First time it was not clear to me the workaround, but now I read it carefully and it worked using Statuses ids. 

The query it works is the  following (at least according to my Statutes configuration):

project = Hemoder-PBM AND status changed from 5 to 10011 ORDER BY created DESC

Where 5 is  To Be Verified and 10011 is In Progress

Thank you very much @Dario B 

[Dario B]

You are very welcome @Nico ! 

I was afraid the workaround was somehow not working anymore, or something similar :)