Status changed from [status] to [Done] not returning results

[Josh Seder]

I would expect this query: project = ODM AND status changed from "TO DO" to "DONE" DURING (2019-01-01, 2019-12-31) to return this issue:

But I don't get any results. Is this a known bug with using status changed from/to? Please help.

[Bill Sheboy · Accepted solution]

Hi @Josh Seder --- Welcome to the Atlassian Community!

Well, that is a defect and I was able to reproduce it.  There is apparently something special about Done status and CHANGED FROM/TO.

It appears you are trying to find all issues in 2019 which jumped from your backlog to done, skipping other workflow steps.  I found a work-around, although it is a bit cumbersome.  If Done won't work, let's instead exclude every other status which was CHANGED FROM during the time frame.

If your workflow was: TO DO, BUILDING, TESTING, and DONE, your query would be:

project = MyProject
 AND status CHANGED FROM "TO DO" DURING (2019-01-01, 2019-12-31)
 AND NOT status CHANGED FROM "BUILDING" DURING (2019-01-01, 2019-12-31)
 AND NOT status CHANGED FROM "TESTING" DURING (2019-01-01, 2019-12-31)

As needed, add/modify additional clauses for AND NOT status CHANGED.  Please respond if this helps find what you need.

One more tip: my teams consider such work items as "abandoned", so we just added a custom field and flag abandoned work as we go.

Best regards,

Bill

[Josh Seder]

Hi @Bill Sheboy - thanks for the response! The work-around you suggested worked, but even more concerning to me is that I'm seeing the same result when I search for issues that changed from "In Progress" to "Done".

Can you also confirm that you can reproduce the issue so I don't lose my sanity?

[Bill Sheboy]

Hi!

You may have overlapping result sets with the queries.  Remember that JQL is not SQL...it is the vendor's own little language. It is unclear to me that it deterministically follows Boolean algebra rules.  Regardless...

The way I verified the original defect you saw was to sample some issues, open each one, and review the activity log to confirm the items did indeed jump from backlog to done.  You could do the same for your new query to investigate what you are observing.

Sorry I cannot be more helpful.  JQL is the only method I know of to query the log information for status transition unless you consider trying the API or some of the marketplace add-ons.

Best regards,

Bill