| || |
RTM report from QC dashboard
Currently I m working under a project which handles large number of requirements on daily basis and frequent changes of those req. To track those req, it's very important to maintain a RTM.
In QC 10.00, I add Reqs in the 'Requirements' tab, design test case in 'Test Plan' tab and then mapped the test case with respective requirements. Now I want to export a report from QC 'Dashboard' which clearly displaying-
1. Requiremet ID
2. Requirement Name
3. Requirement Type
4. Requirement Description
5. Corresponding Test Case ID
6. Corresponding Test Case Name
7. Corresponding Test Case Description
Re: RTM report from QC dashboard
Try this query to excute as per your requirement:
REQ.RQ_REQ_ID AS "Requirement ID",
REQ.RQ_REQ_NAME AS "Requirement Name",
REQ.RQ_REQ_COMMENT As "Requirement Description",
TEST.TS_TEST_ID AS "Test ID",
TEST.TS_NAME AS "Test Name",
INNER JOIN REQ_COVER ON
TEST.TS_TEST_ID = REQ_COVER."RC_ENTITY_ID"
AND REQ_COVER.RC_ENTITY_TYPE = 'TEST'
INNER JOIN REQ ON REQ.RQ_REQ_ID = REQ_COVER.RC_REQ_ID
INNER JOIN ALL_LISTS test_folder ON test_folder.AL_ITEM_ID = TEST.TS_SUBJECT
WHERE TS_USER_15 = 'Give your Test Case Folder Name'