How to find/query reopened work items
Accepted answer
2 other answers
Comments
Generally query against History is pretty useless. cause you need to do math to find anything useful. (how long did it take to do x. how many times did Y occur).. there is no math function in a query.
Trying to find out how many work items got reopened in a given time frame I think is something useful.
1. introduce a "Reopened" status with a transition from the "Closed" status, to find all workitems that have been recently reopened
2. create a custom attribute with a calculated value that is set to some value when a user is reopening the workitem, and query the attribute to find all workitems that have ever been reopened during their lifetime. This can be done with the SDK (perhaps also with JavaScript through process attachments)
Comments
- once they transition out of re-opened, you cannot query that data anymore.
- if it happens AGAIN, then the counter is overlayed, and u lost the fact and impact of the prior event.
the RRDI/Insight ETL create new fact tables from the history that document this data. (time in state and count of state transitions).
Exactly, but the requirements are not clear enough to tell if any of these concerns are an actual problem. Anyway, I agree that the report is a superior solution.
One workaround we thought of for the meantime is to put a tag when a work item gets reopened then query the tag. Of course that doesn't address the old ones.
Yes, that was something along the lines of my second proposition.
I don't think there is a way to address the old ones, other than creating a report, but it might be a candidate for an RFE.