Query Work Item Status Change
We have a extended our Story work item to include an additional state ('delivered'). This is prior to Complete but after In Progress.
We now need to identify which Stories were moved into the 'delivered' state prior to a specific date - this is a query that we'd need to run every 2 or 3 months.
It seems that the Query Editor enables you to search on state and on a planned for . However, planned for can change which does renders the result set unreliable. I also know that we can search on resolution date but these seems to be complete. I do know that the History of each item stores the date it was moved into the next state.
Is there a way to query on the historical date for a status change?
We now need to identify which Stories were moved into the 'delivered' state prior to a specific date - this is a query that we'd need to run every 2 or 3 months.
It seems that the Query Editor enables you to search on state and on a planned for . However, planned for can change which does renders the result set unreliable. I also know that we can search on resolution date but these seems to be complete. I do know that the History of each item stores the date it was moved into the next state.
Is there a way to query on the historical date for a status change?
One answer
To my knowledge, you cannot use "query" to access historical (no longer
current) data ... but you can write reports that do this, since reports
have access to the data warehouse in which you can query for historical
data from each nightly snapshot.
Cheers,
Geoff
kbowkett wrote:
current) data ... but you can write reports that do this, since reports
have access to the data warehouse in which you can query for historical
data from each nightly snapshot.
Cheers,
Geoff
kbowkett wrote:
We have a extended our Story work item to include an additional state
('delivered'). This is prior to Complete but after In Progress.
We now need to identify which Stories were moved into the 'delivered'
state prior to a specific date - this is a query that we'd need to
run every 2 or 3 months.
It seems that the Query Editor enables you to search on state and on a
planned for . However, planned for can change which does renders the
result set unreliable. I also know that we can search on resolution
date but these seems to be complete. I do know that the History of
each item stores the date it was moved into the next state.
Is there a way to query on the historical date for a status change?