Unable to Service Request

Question

Good afternoon,

we are having TFS / MTM TestPlans with a nested Test Suite Structure and I was wondering whether there's any way to query for TestPoints within a given and all children (&-children-children-..) TestSuites. Basically meaning that if I had the following structure:

- TestPlan

-- TestSuite A

--- SubTestSuite B

---- SubSubTestSuite C

---- SubSubSubTestSuite D

I'd like to query for e.g. "give me all TestPoints in TestSuite A and all Sub*TestSuites". Or From "SubSubTestSuiteC + children" I'd like to query for all within that particularly test suite, but also its "SubSubSubTestSuite D".

Is that somehow possible query wise?

Best regards and thanks,

-Jörg

Answer 1

Hi Jörg,

Thank you for your question.

I am trying to involve someone familiar with this topic to further look at this issue. There might be some time delay. Appreciate your patience.

Thank you for your understanding and support.

Best regards,

---

Lily Wu [MSFT]
MSDN Community Support | Feedback to us

Answer 2

Hi,

You can use TFS Object model to query test points under a test suite.

Refer to this article: Using the TFS Object Model to populate Test Details

Generally speaking, Test points =  test case number x test configuration in test plan.  Refer to: http://msdn.microsoft.com/en-us/library/dd286682.aspx

Hope this gets you started.

---

Forrest Guo | MSDN Community Support | Feedback to manager

Answer 3

Forrest,

thanks for your reply. I am well aware of the test case nr x test configuration within one plan constellation, however my original question was geared towards an efficient way to retrieve (query-wise) all of these test points included & within a set of test suites & their child-test suites. I could of course retrieve all test points within one test plan and do the filtering client-side, however - as we will have several (ten)thousand of planned testcase x test configuration test points within one plan, this does not seem like an ideal solution, hence the question regarding a query that might limit the result set to the correct scope.

If I have the Ids of all affected test suites upfront (realistically something around about 100..150 ids), would it make sense to build up a WIQL/TestPoints query or are there any known limitations regarding WHERE constraints in that regard?

Best regards and thanks,

-Jörg

Answer 4

Hi,

I will consult other people if there's better solution. Please wait some time.

best regards,

---

Forrest Guo | MSDN Community Support | Feedback to manager

Answer 5

Will do, thank you Forrest.

Answer 6

I would also suggestion to look at using the TFS object model.

I don't believe It is intrinsically possible to get this information. I would suggest to use the TFS object model. you can use the RecursiveSuiteID Field.

For example
ITestPointCollection tpColl = plan.QueryTestPoints(string.Format("SELECT * FROM TestPoint WHERE RecursiveSuiteID = {0}",parentSuiteID));

If you are not familiar with the TFS object model below are some links to get started with using the TFS object model.

Team Foundation Server SDK Architecture
(2008 article but also applicable for 2010)
http://msdn.microsoft.com/en-us/library/bb130307(v=vs.90).aspx

Getting Up and Running with the TFS 2010 Object Model
http://blogs.msdn.com/b/mvpawardprogram/archive/2011/09/26/getting-up-and-running-with-the-tfs-2010-object-model.aspx

Using the TFS Object Model to populate Test Details
http://blogs.msdn.com/b/paulking/archive/2011/10/12/using-the-tfs-object-model-to-populate-test-details.aspx

 

---

Johnny Coleman [MSFT] Any code posted to this Forum is [As-Is] With No Warranties