Query in RTC
2 answers
Hi Shirit
--> You can create a new query as follows to achieve what you are looking for:
a. Status is: In Progress
b. Then add Date group and select:
Date is not --> Modified --> _ days ago.
--> This will list the work items in the state 'In Progress' and not modified since 10 days ago.
Please see the screenshots on how to select the 'Date' is not modified attribute.
==>
How this works is:
a. A couple of work items are moved to, say 'In Progress' state from 'New' state on 10th February 2015.
b. It lies in 'In Progress' state for 6 days (as of 16th February 2015) with lot of modifications/comments on the work items/ownership change etc.
However, the status of these work items does not change and remains in 'In Progress' state.
c. Now, if you run the query as above, it lists these 2 work items despite modifications at the work item level as the status remains as 'In Progress'.
d. On the contrary, if any of these 2 work items are moved to a different state, say 'stop working' or 'Resolved' without work item modifications, the query does not list that work item because the status has changed.
So the 'Modified' is not reflecting any modification at the defects/work items level but at the status level.
In turn the query I have sent does list the work items that are not modified at their status since 'x' days.
--> You can create a new query as follows to achieve what you are looking for:
a. Status is: In Progress
b. Then add Date group and select:
Date is not --> Modified --> _ days ago.
--> This will list the work items in the state 'In Progress' and not modified since 10 days ago.
Please see the screenshots on how to select the 'Date' is not modified attribute.
==>
How this works is:
a. A couple of work items are moved to, say 'In Progress' state from 'New' state on 10th February 2015.
b. It lies in 'In Progress' state for 6 days (as of 16th February 2015) with lot of modifications/comments on the work items/ownership change etc.
However, the status of these work items does not change and remains in 'In Progress' state.
c. Now, if you run the query as above, it lists these 2 work items despite modifications at the work item level as the status remains as 'In Progress'.
d. On the contrary, if any of these 2 work items are moved to a different state, say 'stop working' or 'Resolved' without work item modifications, the query does not list that work item because the status has changed.
So the 'Modified' is not reflecting any modification at the defects/work items level but at the status level.
In turn the query I have sent does list the work items that are not modified at their status since 'x' days.