1

Resolved

Test Plan Status report fails to filter results by current team project

description

The Test Plan Status repot will return erroneous results if two (or more) Test Plans exist with the same name. This problem crosses Team Project and potentially Team Project Collection boundaries.
 
Steps to reproduce:
  1. In [Team Project 1], create a Test Plan called [Test Plan 1].
  2. In [Test Plan 1] create a Test Suite called [Test Suite 1]
  3. Add a test case to [Test Suite 1]
     
  4. In [Team Project 2]. create a Test Plan called [Test Plan 1]
  5. In [Test Plan 1] create a Test Suite called [Test Suite 2]
  6. Add a test case to [Test Suite 2]
     
  7. Run the Test Plan Status report from [Team Project 1].
  8. Select [Test Plan 1] and run the report.
     
    The report will show [Test Plan 1], [Test Suite 1] and [Test Suite 2] even though it should only show [Test Plan 1] and [Test Suite 1].
     
    The problem is caused by the report query working off the test plan name and not the test plan id.

comments

wrote Sep 12, 2012 at 1:29 AM

Resolved with changeset 99627.

sstjean wrote Sep 12, 2012 at 1:32 AM

** Closed by sstjean 9/11/2012 5:29 PM

sstjean wrote Sep 12, 2012 at 1:32 AM

Should show as Fixed and not Closed

sstjean wrote Sep 12, 2012 at 1:33 AM

Setting to Fixed so that it shows up in the Issues list and is searchable.

JChristenson wrote Sep 14, 2012 at 4:34 PM

We need to add one more filter as TestSuiteID in vDimTestSuiteOverlay is not unique across multiple team project collections.

For example, when I do the following query:
select distinct testsuiteid, teamproject, teamprojectcollection from vdimtestsuiteoverlay

I get this:
1 CSA C-Core
1 CRAW FS-R
1 DW CL-CT
1 OSP FS-B
2 AML FS-R
2 DW CL-CT


In the final select use the following from/inner join:

From dbo.vDimTestSuiteOverlay tso
inner join TestPointRollup tpr
    on tpr.TestSuiteId = tso.TestSuiteID and tso.TeamProject = tpr.TeamProjectProjectNodeName
Order By
...

wrote Feb 14, 2013 at 8:45 PM

wrote May 16, 2013 at 10:26 AM

wrote May 16, 2013 at 10:26 AM

wrote Jun 14, 2013 at 8:12 AM