Highlighted
Absent Member.
Absent Member.
4686 views

Requirement Traceability Matrix extract from ALM

Hi Admin,

 

It would be very helpful if can you please help me with SQL query to generate an excel extract of Requirement Traceability Matrix. I have been doing this manually becuase the query I found on all the blog post fetch all the intances (test runs) of a test case.

 

The column I would need are 

  1. Name ( Field from Requiremnt tab )
  2. Description ( Field from Requiremnt tab)
  3. Linked Test case Name 
  4. Test Case Description
  5. Test Steps
  6. Expected Result
  7. Actual Result
  8. Steps Status ( Only fetch current instance of the test case)
  9. Whether there is any attchement in the test case(s)/step(s) or not
  10. Defect(s) ID linked to the Test case(s)/Step (current instance)
  11. Defect(s) status

 

Thanks for your help in advance

Tags (1)
0 Likes
4 Replies
Highlighted
Honored Contributor.. Honored Contributor..
Honored Contributor..

do you want the linkage between the Run steps as well?

 

As per my understanding your requirement, I wrote the below query, hope this will help you.

 

 

SELECT
   R.RQ_REQ_ID as "REQ_ID",
 R.RQ_REQ_NAME as "REQ_NAME",/*Requirement.Name*/
   R.RQ_REQ_COMMENT as "REQ_Description", /*Requirement.Description*/
  T.TS_TEST_ID as "TEST_ID",
  T.TS_NAME as "TEST_Case_Name",
  T.TS_Description as "TEST_Description" ,
  DS.DS_STEP_NAME as "STEP_NAME",
  DS.DS_Description as "STEP_Description",
  DS.DS_EXPECTED  as "STEP_EXPECTED",
  DS.DS_ATTACHMENT as "Has_Attachment", /*Design Step.Attachment*/
  B.BG_BUG_ID as "Defect_ID",
  B.BG_STATUS as "Defect_STATUS"

FROM REQ R , TEST T ,REQ_COVER RC,  DESSTEPS DS , BUG B , LINK L
where RC.RC_REQ_ID=R.RQ_REQ_ID and RC.RC_ENTITY_ID=T.TS_TEST_ID and RC.RC_ENTITY_TYPE='TEST'
        and  B.BG_BUG_ID=L.LN_BUG_ID and T.TS_TEST_ID=L.LN_ENTITY_ID and LN_ENTITY_TYPE='TEST'
and T.TS_TEST_ID=DS.DS_TEST_ID

 

 

Regards,

Ram

Highlighted
Absent Member.
Absent Member.

Thanks a ton Ramesh, I will run this.

0 Likes
Highlighted
New Member.

Hi Ramesh,

For the below query, is it possible to return those requ ids and Test scripts where defects are not linked.

Mean to say my request id to provide:

Req ID

Req name

Test ID

Test Name

Test Execution Status 

Bug Id

Bug Status

But I also want test script and requirements id where Bugs are not there.They can return value as null

 

Tags (1)
0 Likes
Highlighted
Visitor.

Hi Ramesh, Thanks a lot.

Could you please help providing some SQL which do the following:

In the test lab, I have a folder XYZ. Within this folder XYZ I have test sets with test instances. Now I would like to know if all corresponding test cases have requirements linked to them or not. At the end I should have an overview showing 6 columns:

Test Instance ID

Test: Test Name

Test Case ID

Test Case Name

Reg: QC ID

Reg: Entity Name

 

If a test case has no requirement linked to it, the column Re: QC ID should show EMPTY or NULL.

 

Could you please help me with this? 

Thanks a lot Anthony

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.