How to retreive TestLab execution report using Excel Reports
The below query will give you the Testlab execution report wrt Testlab folder Id's
Select CF_ITEM_NAME FOLDER,
CY_CYCLE TESTSET_NAME,
TEST.TS_NAME TEST_SCRIPT,
RUN.RN_RUN_NAME RUN_NAME,
RN_RUN_ID RUN_ID,
RN_STATUS RUN_EXECUTION_STATUS,
RN_TESTER_NAME LAST_TESTER_NAME ,
RUN.RN_EXECUTION_DATE,
TEST.TS_TEST_ID
FROM CYCLE,RUN,TEST,TESTCYCL, CYCL_FOLD
WHERE CYCLE.CY_FOLDER_ID=CYCL_FOLD.CF_ITEM_ID
AND TESTCYCL.TC_CYCLE_ID=CYCLE.CY_CYCLE_ID
AND TEST.TS_TEST_ID=TESTCYCL.TC_TEST_ID
AND RUN.RN_CYCLE_ID=TESTCYCL.TC_CYCLE_ID
AND TEST.TS_TEST_ID=RUN.RN_TEST_ID
AND (CYCLE.CY_FOLDER_ID in ('1809')) /*Enter the folder Id of TestLab tree */
The below query will give you the Testlab execution report wrt Testlab folder Id's
Select CF_ITEM_NAME FOLDER,
CY_CYCLE TESTSET_NAME,
TEST.TS_NAME TEST_SCRIPT,
RUN.RN_RUN_NAME RUN_NAME,
RN_RUN_ID RUN_ID,
RN_STATUS RUN_EXECUTION_STATUS,
RN_TESTER_NAME LAST_TESTER_NAME ,
RUN.RN_EXECUTION_DATE,
TEST.TS_TEST_ID
FROM CYCLE,RUN,TEST,TESTCYCL, CYCL_FOLD
WHERE CYCLE.CY_FOLDER_ID=CYCL_FOLD.CF_ITEM_ID
AND TESTCYCL.TC_CYCLE_ID=CYCLE.CY_CYCLE_ID
AND TEST.TS_TEST_ID=TESTCYCL.TC_TEST_ID
AND RUN.RN_CYCLE_ID=TESTCYCL.TC_CYCLE_ID
AND TEST.TS_TEST_ID=RUN.RN_TEST_ID
AND (CYCLE.CY_FOLDER_ID in ('1809')) /*Enter the folder Id of TestLab tree */
0 comments:
Post a Comment