Wednesday, 16 October 2013

SQL to pull Dynamic Test Summary Report from ALM ..Quick view about the Project Status!!!!

We often get Queries on the Status of the Execution /Project .Requirement Coverage ,test Case associated with it and Defect if any associated with it.
In ALM we do not have a Standardized Report in the form of Excel/Word doc which just pulls the Report.We end up doing a Manual Work ..Manually pick the Requirements Pick the test case ..then defects if any...Imagine a Project with Multiple Requirements and 1000 Test Cases ..this is almost a impossible task..So Solution??????????

Go to Dashboard in ALM ,Select a New Excel Report ....

Query...

   SELECT t1.RC_REQ_ID AS RequirementID,
  t1.RQ_REQ_NAME    AS REQUIREMENTDESC,
  t1.TS_NAME        AS TESTCASENAME,
  BG_BUG_ID         AS DEFECTID,
  BG_SUMMARY,
  BG_DESCRIPTION
FROM
  (SELECT *
  FROM REQ R,
    REQ_COVER RC,
    TEST T
  WHERE RC_ENTITY_ID=T.TS_TEST_ID
  AND Rq_req_product='PROJECT NAME'
  AND R.RQ_REQ_ID   =RC.RC_REQ_ID
  )T1
LEFT OUTER JOIN
  ( SELECT * FROM LINK L,BUG B WHERE L.LN_BUG_ID=B.BG_BUG_ID
  )T2
ON T1.TS_TEST_ID       =T2.LN_ENTITY_ID
AND T2.LN_ENTITY_TYPE IN ('TEST','TESTCYCL')
AND BG_PROJECT         ='PROJECT NAME'




Report Done!!!!!!!!!!!!!!
Let us know if you need any assistance.

1 comment:

  1. Excellent post and it also comprises a lot of useful facts- Thanks for valuable information. Really enjoyed reading it. Please visit my emc testing page and please leave comments.

    ReplyDelete