How can you find out which Test Definitions are linked to a particular issue (defect) in SilkCentral Test Manager?

0 Likes

Problem:

How can you find out which Test Definitions are linked to a particular issue (defect) in SilkCentral Test Manager?

Resolution:

QUESTION
----------------------------------

How can you find out which Test Definitions are linked to a particular issue (defect) in SilkCentral Test Manager?

ANSWER
----------------------------------

To find out which test definitions are linked with a certain issue (defect) you can use an advanced query. See the example below:

SELECT * FROM RTM_V_TestDefinitions r INNER JOIN (SELECT DISTINCT  i.NodeID_fk as id FROM TM_Issues i  
WITH (NOLOCK) INNER JOIN TM_PlanTreePaths ptp  WITH (NOLOCK) ON i.NodeID_fk = ptp.NodeID_pk_fk INNER JOIN 
TM_TestContainers tc WITH (NOLOCK)  ON ptp.ParentNodeID_pk_fk = tc.TestContainerID_pk_fk WHERE ProjectID_fk 
= 0 AND i.ExternIssueID= "${ID|1|ExternalID}") data ON data.id = r.TestID


In the parameter tab you can specify the required issue id. For example if you are using ClearQuest you enter in the ClearQuestID.

Old KB# 24641
Comment List
Anonymous
Related Discussions
Recommended