Extract list of defects having status changed in a given period

Shamsher Khan

Hi, need to generate historical report of all defects which have undergone a status change from A to B (say from Open to FIXED) for set time periods (eg, between 1st Oct-31st Oct). It should also contain the date when defect was changed to FIXED.

At the moment first part is working (list can be extracted) but can't extract the exact date/time when the status was changed as can't find a corresponding field in the exported fields though the query seem to use one. For first part, I am using the query :

project = "xxxtions" AND status changed to fixed before "2018-09-30" and status changed to fixed after "2018-09-01"

 

Please help.

unknown

Hi @Shamsher Khan,

The timestamp information is not available other than viewing it within the issue's history. You would need to use a script that gets the timestamp of that particular status change and dumps the date information into something like a custom field present on the issue. Though if the transition happens more than once then does the latest transition override the previous?

There is a possible problem you may have with your current query; the defect could have been moved back into another status though the current query still picks up the issue. I suggest adding " AND status = fixed". 

Let me know your thoughts