It is possible to use the "History" tab in queries?
One answer
Hi Ziv,
I tried playing around with this. The best I could do in a query was to query for work items in the reopened state that were modified between two dates. This doesn't really solve the problem, because the work items you're looking for may no longer be in the reopened state, and the work items returned in the query could have been modified in some other way (like the owner changed) between those two dates.
I did a quick search, and found this forum post which suggests using Reports to gather this information: https://jazz.net/forum/questions/80170/is-it-possible-to-query-on-state-transitions-of-work-items.
I tried playing around with this. The best I could do in a query was to query for work items in the reopened state that were modified between two dates. This doesn't really solve the problem, because the work items you're looking for may no longer be in the reopened state, and the work items returned in the query could have been modified in some other way (like the owner changed) between those two dates.
I did a quick search, and found this forum post which suggests using Reports to gather this information: https://jazz.net/forum/questions/80170/is-it-possible-to-query-on-state-transitions-of-work-items.