Requirement Traceability Matrix extract from ALM

0 Likes
over 2 years ago

Here is an example SQL query showing:

  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
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

Labels:

How To-Best Practice
Comment List
Anonymous
Related Discussions
Recommended