We have a process where Finance once a month extract issues that are changed to Done during e.g. January 2021. That's not a problem; However we experience that if e.g. a Story during January accidently change status to Done the Status Changed date is updated (of course). However, if then the status is changed to any other status and then back into Done during e.g. February - then Status Changed date is not updated (it seems to keep the date for the first "Done". Is that right?
Jira should be keeping track of all the status changes, which should be queryable using the WAS operator. Look on this page for some examples: https://support.atlassian.com/jira-software-cloud/docs/advanced-search-reference-jql-operators/
In your example, is correct that the issue WAS Done in January, from a JQL perspective. You may want to expand your query to exclude those accidents, something like status WAS Done DURING (
"2021/01/01","2021/01/31") AND NOT status CHANGED AFTER "2021/02/01"
I am wondering... Isn't the CHANGED AFTER operator date-based and also equates to greater than not greater than or equal to? So using "2020/02/01" could allow things un-Done on 2/1 to slip through, right? Or is the time implied to be 00:00 for these?
Would this be better?
status WAS Done DURING (
AND NOT status CHANGED AFTER
If I have this wrong, please let me know. Thanks!
Catch up with Atlassian Product Managers in our 2020 Demo Den round-up! From Advanced Roadmaps to Code in Jira to Next-Gen Workflows, check out the videos below to help up-level your work in the new ...
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