Monday, January 3, 2011

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 ('23772')) /*Enter the folder Id of TestLab tree */
Posted by at
Labels:

2 comments:

  1. Vishwak ReddyJuly 26, 2011 at 6:05 AM

    This comment has been removed by the author.

    ReplyDelete
  2. Vishwak ReddyJuly 26, 2011 at 6:11 AM

    Here is the query to get "FOLDER ID"

    SELECT FOLD1.CF_ITEM_NAME AS Folder_Name, FOLD1.CF_ITEM_ID AS Folder_ID,
    FOLD10.CF_ITEM_NAME||'\'||FOLD9.CF_ITEM_NAME||'\'||FOLD8.CF_ITEM_NAME||'\'||FOLD7.CF_ITEM_NAME||'\'||FOLD6.CF_ITEM_NAME||'\'||FOLD5.CF_ITEM_NAME ||'\'||FOLD4.CF_ITEM_NAME ||'\'||FOLD3.CF_ITEM_NAME||'\'||FOLD2.CF_ITEM_NAME AS Path
    FROM CYCL_FOLD FOLD1, CYCL_FOLD FOLD2, CYCL_FOLD FOLD3, CYCL_FOLD FOLD4, CYCL_FOLD FOLD5, CYCL_FOLD FOLD6, CYCL_FOLD FOLD7, CYCL_FOLD FOLD8, CYCL_FOLD FOLD9, CYCL_FOLD FOLD10
    WHERE FOLD2.CF_ITEM_ID = FOLD1.CF_FATHER_ID
    AND FOLD3.CF_ITEM_ID (+) = FOLD2.CF_FATHER_ID
    AND FOLD4.CF_ITEM_ID (+) = FOLD3.CF_FATHER_ID
    AND FOLD5.CF_ITEM_ID (+) = FOLD4.CF_FATHER_ID
    AND FOLD6.CF_ITEM_ID (+) = FOLD5.CF_FATHER_ID
    AND FOLD7.CF_ITEM_ID (+) = FOLD6.CF_FATHER_ID
    AND FOLD8.CF_ITEM_ID (+) = FOLD7.CF_FATHER_ID
    AND FOLD9.CF_ITEM_ID (+) = FOLD8.CF_FATHER_ID
    AND FOLD10.CF_ITEM_ID (+) = FOLD9.CF_FATHER_ID
    and (FOLD1.CF_ITEM_NAME LIKE 'Folder Name')

    ReplyDelete

Subscribe to: Post Comments (Atom)