Labels

Thursday, July 26, 2012

Quality Center SQL for TestPlan path,Testname,ID,TestDescription Report?

SELECT FOLD1.AL_DESCRIPTION AS Folder_Name, FOLD1.AL_ITEM_ID AS Folder_ID,
       FOLD10.AL_DESCRIPTION||'\'||FOLD9.AL_DESCRIPTION||'\'||FOLD8.AL_DESCRIPTION||'\'||FOLD7.AL_DESCRIPTION||'\'||FOLD6.AL_DESCRIPTION||'\'||FOLD5.AL_DESCRIPTION ||'\'||FOLD4.AL_DESCRIPTION ||'\'||FOLD3.AL_DESCRIPTION||'\'||FOLD2.AL_DESCRIPTION AS Path,
TEST.TS_NAME TestName,TEST.TS_TEST_ID TestID,TEST.TS_DESCRIPTION Description
FROM   ALL_LISTS FOLD1, ALL_LISTS FOLD2, ALL_LISTS FOLD3, ALL_LISTS FOLD4, ALL_LISTS FOLD5, ALL_LISTS FOLD6, ALL_LISTS FOLD7, ALL_LISTS FOLD8,  ALL_LISTS FOLD9, ALL_LISTS FOLD10,TEST
WHERE  FOLD2.AL_ITEM_ID = FOLD1.AL_ITEM_ID
   AND FOLD3.AL_ITEM_ID (+) = FOLD2.AL_FATHER_ID
   AND FOLD4.AL_ITEM_ID (+) = FOLD3.AL_FATHER_ID
   AND FOLD5.AL_ITEM_ID (+) = FOLD4.AL_FATHER_ID
   AND FOLD6.AL_ITEM_ID (+) = FOLD5.AL_FATHER_ID
   AND FOLD7.AL_ITEM_ID (+) = FOLD6.AL_FATHER_ID
   AND FOLD8.AL_ITEM_ID (+) = FOLD7.AL_FATHER_ID
   AND FOLD9.AL_ITEM_ID (+) = FOLD8.AL_FATHER_ID
   AND FOLD10.AL_ITEM_ID (+) = FOLD9.AL_FATHER_ID
   AND TEST.TS_SUBJECT= FOLD1.AL_ITEM_ID
   AND TS_TEST_ID in(10,12)          /* User AL_ITEM_ID for folder level*/

1 comment:

  1. This is the right web site for anyonе who wants to understanԁ this topic.
    You realizе so much itѕ аlmost hard to argue with you
    (not that I reallу ωill need to…HaHа).

    You definitely put a new spin on a subϳect that has been
    wrіttеn about foг ages. Gгeat stuff, juѕt eхcеllent!


    Feel frеe to visіt my blog ...
    ramаdan 2013, ,

    ReplyDelete