Status no longer works in searches using "changed to"

Daniel Covill April 16, 2021

I used to be able to run a search with the following and get good results.

project = smart and status changed to Done during (-70d, 0d)

Now the above search returns zero results in spite of the search below returning many results, all well within the expected timeframe:

project = smart and status = done

I have three projects in my Jira cloud account. If I remove the project from the top query, I get a lot of results but only for one of the projects. All of the projects have a state called "Done". What could be causing this?

 

edit: I did recently change the ordering of statuses in /secure/admin/ViewStatuses.jspa. Is it possible Jira has lost all the history for status changes because of that? 

2 answers

1 accepted

2 votes
Answer accepted
Bill Sheboy
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
April 16, 2021

Hi @Daniel Covill 

My understanding is that symptom can happen when you use any Team-managed (formerly called Next-Gen) projects in you instance.  Are you doing so?

If so, the cause appears to be each project has it's own version of each status, and so CHANGED, WAS, etc. get confused.  The work-around is to use the specific status ID value.

project = myProject AND status CHANGED TO 12345 DURING (-70d, 0d)

Your site admin should be able to determine the specific status ID for you.

 

Best regards,

Bill

Daniel Covill April 16, 2021

This was the answer. 

Like # people like this
Bill Sheboy
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
April 16, 2021

Here are the two defects for this symptom.  You can watch them and/or mark that they impact your team.

Like # people like this
Italo _Modus Create_
Contributor
April 16, 2021

@Bill Sheboy thanks for sharing!! 

Like Bill Sheboy likes this
0 votes
Italo _Modus Create_
Contributor
April 16, 2021

Hi @Daniel Covill ,

You JQL looks good and reorder statuses should be a reason to lost history of status change, this information is stored in the issue changelog.

I would recommend you to open a ticket to Atlassian support because this might be some issue in your instance and they will be able to provide you the troubleshooting steps.

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
TAGS
AUG Leaders

Atlassian Community Events