Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

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

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.

1 answer

3 votes
Dario B Atlassian Team Nov 15, 2019

Hi @Brandon Hite ,

You are facing the bug tracked in our system as:

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

 

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

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 Atlassian Team Aug 05, 2021

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:

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 

Like Dario B likes this
Dario B Atlassian Team Aug 10, 2021

You are very welcome @Nico ! 

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

Like Nico likes this

Suggest an answer

Log in or Sign up to
This widget could not be displayed.
TAGS

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you