meeraG Absent Member.
Absent Member.
511 views

get number of test cases in test set

Hi 

 

please if any one can help me into this.

following query is to get records from test lab.

I want number of test cases in each test set.

i am not getting any way to retrive this.

please help

 

SELECT  TSFP.CF_ITEM_NAME       as "Test Set Parent Folder"                           ,
        TSF.CF_ITEM_NAME        as "Test Set Folder"                                  ,
        TS.CY_CYCLE             as "Test Set"                                         ,
        TS.CY_CYCLE_ID          as "Test Set ID"                                      ,
        TC.TC_TEST_ORDER        as "Test Order"  /*Test Instance.Test Order*/         ,
        TC.TC_TEST_ID           as "Test ID"                                          ,
        T1.TS_NAME              as "Test Name"  /*Test.Test Name*/                    ,
        TC.TC_TEST_INSTANCE     as "Test Instance"                                    ,
        T1.TS_USER_02           as "Team"                                             ,
        T1.TS_USER_05           as "Object ID"                                        ,
        T1.TS_USER_01           as "TCode"                                            ,
        RUN.RN_STATUS           as "Run Status"   /*Run.Status*/                      ,
        TC.TC_TESTER_NAME       as "Responsible Tester"                               ,
        TC.TC_ACTUAL_TESTER     as "Actual Tester"                                    ,
        RUN.RN_EXECUTION_DATE   as "Run Date"  /*Run.Exec Date*/                      ,
       RUN.RN_RUN_NAME         as "Run Name"   /*Run.Run Name*/                      ,
        RUN.RN_EXECUTION_DATE   as "Run Date"   /*Run.Exec Date*/                     ,
        RUN.RN_EXECUTION_TIME   as "Run Exec Time"  /*Run.Exec Time*/                 ,
        RUN.RN_DURATION         as "Run Duration" /*Run.Duration*/                    ,
        RUN.RN_TESTER_NAME      as "Run Tester"   /*Run.Tester*/
From       TESTCYCL    "TC"     /*Test Instance*/
Left Join  RUN
  on      (TC.TC_TESTCYCL_ID       =  RUN.RN_TESTCYCL_ID)
  Join       CYCLE       "TS"     /*Test Set*/
  on      (TS.CY_CYCLE_ID          = TC.TC_CYCLE_ID
  and      TS.CY_CYCLE_ID          = RUN.RN_CYCLE_ID)
Left Join  CYCL_FOLD   "TSF"    /*Test Set Folder*/
   on      TSF.CF_ITEM_ID          = TS.CY_FOLDER_ID
Left Join  CYCL_FOLD   "TSFP"   /*Test Set Parent Folder*/
   on      TSFP.CF_ITEM_ID         = TSF.CF_FATHER_ID
Left Join  TEST        "T1"     /*Test*/
   on     (T1.TS_TEST_ID           = TC.TC_TEST_ID)
Order By "Test Set Folder"                 ,
         "Test Set"                        ,
         "Test Order"                      ,
         "Test Name"                       ,
          RUN.RN_EXECUTION_DATE   DESC     ,
          RUN.RN_EXECUTION_TIME   DESC

Tags (1)
0 Likes
2 Replies
Absent Member.. Trudy Claspill Absent Member..
Absent Member..

Re: get number of test cases in test set

Could you explain to us in words the full scope of what you are trying to get, so that we don't have to decipher your query?

 

An example of the desired output would also be a good explanation.

[If this post solves or helps solve your issue, mark the thread as solved and give KUDOS to the author for their assistance.]

(Opinions expressed in my postings are mine alone, and do not reflect the opinions of my employer.No warranties express or implied for any solution/suggestion posted.)
0 Likes
meeraG Absent Member.
Absent Member.

Re: get number of test cases in test set

Hey trudy thanks for ur reply

 

consider example

In test lab one test set contains 10 test cases executed.

I want this number of test cases in one test set.

query should fetch count of test cases from particular test set.

 

TEST SET ID=2 this test set contains following test cases executed

Test case ID = 91

Test case ID = 92

Test Case ID = 93

 

 

so query should return 3 as count of test cases.

 

i have following query

SELECT  TSF.CF_ITEM_ID "Sub Folder Id",  TSF.CF_ITEM_NAME "Sub Folder Name",
TSFP.CF_ITEM_NAME       as "Test Set Parent Folder"                           ,
  TSF.CF_ITEM_ID "Test Set Folder Id",
        TSF.CF_ITEM_NAME        as "Test Set Folder"                                  ,
        TS.CY_CYCLE             as "Test Set"                                         ,
        TS.CY_CYCLE_ID          as "Test Set ID"                                      ,
        TC.TC_TEST_ORDER        as "Test Order"  /*Test Instance.Test Order*/         ,
        TC.TC_TEST_ID           as "Test ID"                                          ,
        T1.TS_NAME              as "Test Name"  /*Test.Test Name*/                    ,
        TC.TC_TEST_INSTANCE     as "Test Instance"                                    ,
        T1.TS_USER_02           as "Team"                                             ,
        T1.TS_USER_05           as "Object ID"                                        ,
        T1.TS_USER_01           as "TCode"                                            ,
        RUN.RN_STATUS           as "Run Status"   /*Run.Status*/                      ,
        TC.TC_TESTER_NAME       as "Responsible Tester"                               ,
        TC.TC_ACTUAL_TESTER     as "Actual Tester"                                    ,
        RUN.RN_RUN_NAME         as "Run Name"   /*Run.Run Name*/                      ,
        RUN.RN_EXECUTION_DATE   as "Run Date"   /*Run.Exec Date*/                     ,
        RUN.RN_EXECUTION_TIME   as "Run Exec Time"  /*Run.Exec Time*/                 ,
        RUN.RN_DURATION         as "Run Duration" /*Run.Duration*/                    ,
        RUN.RN_TESTER_NAME      as "Run Tester"   /*Run.Tester*/
From       TESTCYCL    "TC"     /*Test Instance*/
Left Join  RUN
  on      (TC.TC_TESTCYCL_ID       =  RUN.RN_TESTCYCL_ID)
  Join       CYCLE       "TS"     /*Test Set*/
  on      (TS.CY_CYCLE_ID          = TC.TC_CYCLE_ID
  and      TS.CY_CYCLE_ID          = RUN.RN_CYCLE_ID)
Left Join  CYCL_FOLD   "TSF"    /*Test Set Folder*/
   on      TSF.CF_ITEM_ID          = TS.CY_FOLDER_ID
Left Join  CYCL_FOLD   "TSFP"   /*Test Set Parent Folder*/
   on      TSFP.CF_ITEM_ID         = TSF.CF_FATHER_ID
Left Join  TEST        "T1"     /*Test*/
   on     (T1.TS_TEST_ID           = TC.TC_TEST_ID)
Order By "Test Set Folder"                 ,
         "Test Set"                        ,
         "Test Order"                      ,
         "Test Name"                       ,
          RUN.RN_EXECUTION_DATE   DESC     ,
          RUN.RN_EXECUTION_TIME   DESC

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.