Labels

Thursday, April 11, 2013

How to know what test scripts are assigned to Tester for execution.

Below is the query to pull the test scripts which are assigned to Testers for execution:

SELECT FOLD1.CF_ITEM_NAME AS Folder_Name, Substr(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,12-length(fold1.cf_item_path)/3)||'\'||FOLD1.CF_ITEM_NAME AS FolderPath,
CYCLE.CY_CYCLE TestSet_Name,
TEST.TS_NAME TestScript_Name,
TESTCYCL.TC_STATUS LastExec_Status, TESTCYCL.TC_TESTER_NAME ResposibleTester
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,CYCLE,TEST,TESTCYCL
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 CYCLE.CY_FOLDER_ID   = FOLD1.CF_ITEM_ID
AND TESTCYCL.TC_CYCLE_ID = CYCLE.CY_CYCLE_ID
AND TEST.TS_TEST_ID      = TESTCYCL.TC_TEST_ID
AND (CYCLE.CY_FOLDER_ID in (SELECT B.CF_ITEM_ID FROM CYCL_FOLD A, CYCL_FOLD B Where A.CF_ITEM_ID in (folder id) and Instr(B.CF_ITEM_PATH, A.CF_ITEM_PATH)=1))     /* Enter value for Labfolderid CF_ITEM_ID*/

No comments:

Post a Comment