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.

[Matthias Gaiser _K15t_]

Hi @Shamsher Khan,

while @[deleted] is technically correct, there might still be a possibility to get what you need depending on your configuration. Do you also set the resolution field when you set the status to fixed?

If yes, you could check the Resolution Date field which shows the date/time when the resolution was set.

Cheers,
Matthias.

[Deleted user]

Thanks @Matthias Gaiser _K15t_,

Learnt something new today, though would this not suffer form the same issue that I mentioned previously?

[Matthias Gaiser _K15t_]

You are correct, @[deleted]. I'd also expand the JQL as you suggested.

[Deleted user]

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

[Deleted user]

Hi @Shamsher Khan,

Could you screenshot the defect's workflow and transitions?