Automation Testing, Manual Testing, QTP/UFT 11 , QC/ALM 11 ,SAP TAO, Unix, Selenium, Oracle SQL, Shell Scripting and For Online Trinings to contact me : Cell:+91-8897972059 , Email Id : quicktestprotech@gmail.com

Tuesday, March 25, 2014

How to retreive TestLab execution report using Excel Reports

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

0 comments:

Post a Comment

Loading...