SPONSORS:






User Tag List

Thanks Thanks:  0
Likes Likes:  0
Dislikes Dislikes:  0
Page 1 of 2 12 LastLast
Results 1 to 10 of 12
  1. #1
    Apprentice
    Join Date
    Jun 2012
    Posts
    20
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Total Step report with execution status

    Hi All,

    I need to generate a report with test case name , total steps and count of passed/failed steps .

    for example if test case 1 contains 50 steps of which 30 steps are passed , 2 failed and remining 18 not completed then i need a report as

    Test name - step count - no of passed steps - no of failed steps - no of not completed steps

    please help me in generating this report by using sql query

    I am using HPALM 11

  2. #2
    Advanced Member
    Join Date
    Nov 2006
    Posts
    821
    Post Thanks / Like
    Mentioned
    3 Post(s)
    Tagged
    2 Thread(s)
    Total Downloaded
    0

    Re: Total Step report with execution status

    What if the test case has been run multiple times? Do you want your report to include the pass/fail status of all steps in all runs of the test?
    Trudy C
    (Opinions and information contained in this post are wholly my own and do not reflect the opinions of my employer.)

  3. #3
    Apprentice
    Join Date
    Jun 2012
    Posts
    20
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: Total Step report with execution status

    Yes Trudy I want to include all the pass/fail status of steps.

  4. #4
    Advanced Member
    Join Date
    Nov 2006
    Posts
    821
    Post Thanks / Like
    Mentioned
    3 Post(s)
    Tagged
    2 Thread(s)
    Total Downloaded
    0

    Re: Total Step report with execution status

    Do you know how to write SQL queries? Have you reviewed the QC Database Reference document?

    Show us what you have so far.
    Trudy C
    (Opinions and information contained in this post are wholly my own and do not reflect the opinions of my employer.)

  5. #5
    Apprentice
    Join Date
    Jun 2012
    Posts
    20
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: Total Step report with execution status

    right now i have this report which gives total no of steps

    SELECT
    CF_ITEM_NAME as "Test Lab Folder Name",
    CYCLE.CY_CYCLE as "Test Set",
    ALL_LISTS.AL_DESCRIPTION as "Description",
    TS_TEST_ID AS "Test Case ID",
    TS_STEPS AS "No. of Steps",
    TS_NAME AS "Test Case Name",
    RUN.RN_STATUS as "Run Status",
    RUN.RN_TESTER_NAME as "Tester",

    FROM CYCL_FOLD
    LEFT OUTER JOIN CYCLE
    ON CYCL_FOLD.CF_ITEM_ID=CYCLE.CY_FOLDER_ID
    LEFT OUTER JOIN TESTCYCL
    ON TESTCYCL.TC_CYCLE_ID = CYCLE.CY_CYCLE_ID
    --LEFT OUTER JOIN RUN /*Run*/
    --ON TESTCYCL.TC_TESTCYCL_ID = RUN.RN_TESTCYCL_ID
    LEFT OUTER JOIN
    (select * from run where rn_run_id in
    (select max(rn_run_id) from run group by rn_testcycl_id)) RUN /*Run*/
    ON TESTCYCL.TC_TESTCYCL_ID = RUN.RN_TESTCYCL_ID
    LEFT JOIN TEST ON TS_TEST_ID = TC_TEST_ID
    LEFT OUTER JOIN ALL_LISTS
    ON TEST.TS_SUBJECT = ALL_LISTS.AL_ITEM_ID
    LEFT OUTER JOIN RELEASE_CYCLES
    ON TESTCYCL.TC_ASSIGN_RCYC=RELEASE_CYCLES.RCYC_ID
    WHERE
    --CF_ITEM_PATH LIKE 'AAA'
    ORDER BY CF_ITEM_PATH

    but i don't know how to get number of passed and failed steps from that total no of steps . Please help

  6. #6
    Apprentice
    Join Date
    Jun 2012
    Posts
    20
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: Total Step report with execution status

    can we get the total passed and failed steps at test set level ?

  7. #7
    Advanced Member
    Join Date
    Nov 2006
    Posts
    821
    Post Thanks / Like
    Mentioned
    3 Post(s)
    Tagged
    2 Thread(s)
    Total Downloaded
    0

    Re: Total Step report with execution status

    Are you "MACHMAN" on the HP Communities forums? If so, I'm the same "Trudy" already talking to you there. I'm still trying to work out a solution. I've done something similar to what you're trying using the pivot table feature of SQL. Haven't been able to twist my previous work to fit your need yet.
    Trudy C
    (Opinions and information contained in this post are wholly my own and do not reflect the opinions of my employer.)

  8. #8
    Advanced Member
    Join Date
    Nov 2006
    Posts
    821
    Post Thanks / Like
    Mentioned
    3 Post(s)
    Tagged
    2 Thread(s)
    Total Downloaded
    0

    Re: Total Step report with execution status

    This is close to what you want. The query gets a table of data with the following column names
    "Test Set Folder Name",
    "Test Set Name",
    "Test Case Name",
    "Test Plan Folder Name",
    "No. of Test Steps in Plan",
    "Status of most recent Run of Test",
    "Tester",
    "Run ID",
    "Passed",
    "Failed",
    "No Run"

    In the last three columns are counts of the number of execution steps in each category for the test instance.

    Only the most recent run of a test instance is included.

    Since the core SELECT statement is based off of RUN, if a test instance has no run, then it will not be included.

    I have noticed that if a test is run with Sprinter, the executed step information is not stored in the STEP table. I have a thread open on the HP ALM Customer Support forum asking about this. So, if a manual test is run with Sprinter, if will show all zeros in the last columns.

    <font class="small">Code:</font><hr /><pre>
    select
    CF_ITEM_NAME AS "Test Set Folder Name",
    CY_CYCLE as "Test Set Name",
    TS_NAME as "Test Case Name",
    AL_DESCRIPTION as "Test Plan Folder Name",
    TS_STEPS as "No. of Test Steps in Plan",
    RN_STATUS as "Status of most recent Run of Test",
    RN_TESTER_NAME as "Tester",
    RN_RUN_ID,
    [Passed],
    [Failed],
    [No Run]
    from
    (
    select
    CF_ITEM_NAME,
    CY_CYCLE,
    TS_NAME,
    AL_DESCRIPTION,
    TS_STEPS,
    TC_TEST_ID,
    [Test Instance ID],
    [MAX RUN ID],
    RN_STATUS,
    RN_TESTER_NAME,
    RN_RUN_ID,
    ST_ID,
    ST_STATUS
    from
    (
    select
    rn_testcycl_id as "Test Instance ID" ,
    max(rn_run_id) AS "MAX RUN ID"
    from
    run
    group by
    rn_testcycl_id
    ) rundata
    LEFT OUTER JOIN STEP on rundata.[MAX RUN ID]=STEP.ST_RUN_ID
    left outer join testcycl on rundata.[Test Instance ID]=TESTCYCL.TC_TESTCYCL_ID
    LEFT OUTER JOIN TEST ON TESTCYCL.TC_TEST_ID=TEST.TS_TEST_ID
    LEFT OUTER JOIN CYCLE ON TESTCYCL.TC_CYCLE_ID = CYCLE.CY_CYCLE_ID
    LEFT OUTER JOIN CYCL_FOLD ON CYCLE.CY_FOLDER_ID=CYCL_FOLD. CF_ITEM_ID
    LEFT OUTER JOIN ALL_LISTS ON TEST.TS_SUBJECT=ALL_LISTS.AL_ITEM_ID
    left outer join RUN ON rundata.[MAX RUN ID]=RUN.RN_RUN_ID
    ) SOURCE

    pivot
    (
    count(SOURCE.ST_ID) FOR SOURCE.ST_STATUS
    in ([Passed],[Failed],[No Run])
    ) as pvt

    order by CF_ITEM_NAME, CY_CYCLE, TS_NAME asc
    </pre><hr />

    As I said, it will only report on Tests that have a Test Instance in the Test Lab with an associated Run. If you want it to report on all Test Instances including ones that haven't been run, it will need to be reworked.

    Also, as it is, it does not accommodate other Run Step statuses, like Blocked.
    Trudy C
    (Opinions and information contained in this post are wholly my own and do not reflect the opinions of my employer.)

  9. #9
    Apprentice
    Join Date
    Jun 2012
    Posts
    20
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: Total Step report with execution status

    Trudy it worked like champ . Thanks for your help but i have a small doubt

    what if a test script has call steps in it . its showing as step count as 1 and passed counts as 8 so on. we have lot of call steps in the scripts

  10. #10
    Advanced Member
    Join Date
    Nov 2006
    Posts
    821
    Post Thanks / Like
    Mentioned
    3 Post(s)
    Tagged
    2 Thread(s)
    Total Downloaded
    0

    Re: Total Step report with execution status

    That is because your original query refers back to the test case from the Test Plan to get the number of steps. When you have a test that calls another test case, in the Test Plan you see just one step that shows the Call To Test. In the Test Instance Run Steps, the steps from the called test are expanded and pasted in. If you want the step count from the STEPS table rather than the Test Plan, the query needs to be changed.
    Trudy C
    (Opinions and information contained in this post are wholly my own and do not reflect the opinions of my employer.)

 

 
Page 1 of 2 12 LastLast

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Search Engine Optimisation provided by DragonByte SEO v2.0.36 (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
Resources saved on this page: MySQL 11.54%
vBulletin Optimisation provided by vB Optimise v2.6.4 (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
User Alert System provided by Advanced User Tagging v3.2.8 (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
vBNominate (Lite) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
Feedback Buttons provided by Advanced Post Thanks / Like (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
Username Changing provided by Username Change (Free) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
BetaSoft Inc.
Digital Point modules: Sphinx-based search
All times are GMT -8. The time now is 06:13 PM.

Copyright BetaSoft Inc.