Possibility to show plan items affected by active defects
In the RTC (3.0.1) eclipse client I defined a simple query to show all plan items that are affected by at least a defect. This query return all plans items affected by a defect independently by the defect status.
I would create a query to show all plan items affected by active (not resolved) defects and possibly filter by severity also.
Is it possible?
Thanks
I would create a query to show all plan items affected by active (not resolved) defects and possibly filter by severity also.
Is it possible?
Thanks
2 answers
I am running RTC 4.0, but I do not think it should be too different.
In team artifacts view,
1) Find your project
2) Expand it
3) Right click work items
4) New->Query
5) Start from scratch
6) In the Conditions tab
7) Click the add button in the top right
8) Add Conditions
9) Check "Show Built-in"
10) Find "Status"
11) Click ok
12) Check "Unresolved"
13) Click the add button in the top right
14) Add Conditions
15) Check "Show links"
16) Find "Affected by Defect"
17) Make sure it says exist
18) In the "Column Display" tab
19) Under Sorting
20) Find "Severity"
21) Add "Severity" to the "Selected sort columns"
22) Click "Run"
Comments
Joseph's query is doing almost the right thing for the first part of your question. Just add another condition for "Type" and check "Plan Item" so that your query reads:
[Type is "Plan Item" AND Status is "Unresolved" AND Affected by Defect "exists"]
We currently do not support reasoning about attributes of linked work items for that link type. I opened an enhancement to track this request Work Item Queries: Support reasoning about attributes of linked work items for CLM link types (246420). Just FYI, to see what's currently possible in RTC I recommend the article Advanced User's Guide to Querying Work Items in Rational Team Concert. In particular the section "Link Queries" should be of interest.