Requirement Traceability Matrix extract from ALM
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
- Name ( Field from Requiremnt tab )
- Description ( Field from Requiremnt tab)
- Linked Test case Name
- Test Case Description
- Test Steps
- Expected Result
- Actual Result
- Steps Status ( Only fetch current instance of the test case)
- Whether there is any attchement in the test case(s)/step(s) or not
- Defect(s) ID linked to the Test case(s)/Step (current instance)
- Defect(s) status
Thanks for your help in advance
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
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:
Test Execution Status
But I also want test script and requirements id where Bugs are not there.They can return value as null
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