SPONSORS:






User Tag List

Thanks Thanks:  0
Likes Likes:  0
Dislikes Dislikes:  0
Results 1 to 3 of 3
  1. #1
    New Member
    Join Date
    Dec 2014
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Test Lab Report - Excel Report

    Hello all,

    I am trying to export the test results of a certain folder (and all subfolders including test sets) in the Test Lab.
    Currently I have tried to export these test results based on the folder ID and/or folder path. I receive some results, but still not what I expect. I receive several lines for 1 test case, while I expect to have 1 line for 1 test case with it's status.

    The report should contain the executed test cases, but the test cases in status 'no run' as well.
    The query I made is the following (but wich is not correct):

    SELECT
    CF_ITEM_ID as "Folder ID",
    CF_ITEM_NAME as "Test Set Folder Name",
    CY_CYCLE as "Test Set Name",
    TS_NAME as "Test Case Name",
    TESTCYCL.TC_STATUS as "Test Case Status"

    FROM
    TEST,
    CYCLE,
    TESTCYCL,
    CYCL_FOLD

    where
    TESTCYCL.TC_TEST_ID=TS_TEST_ID and
    CF_ITEM_ID=CY_FOLDER_ID and
    CF_ITEM_ID = XXXX (FOlder ID)

    ORDER BY
    CF_ITEM_ID, CY_CYCLE


    Does someone perhaps happen to have a usable query for a similar report?
    Thanks in advance,
    KR,

    AEB

  2. #2
    Member meridian_05's Avatar
    Join Date
    Feb 2011
    Location
    Chiswick, London
    Posts
    156
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0
    Hi AEB,

    Try the following queries.

    You'll firstly need to ascertain the Folder Path name of the top level folder that you want to report on. The folders in Test Lab follow a “AAABBBCCC*” naming convention, where the lower level folders contain the path name of the upper level folders plus AAA, AAB, etc

    To run a report to get the folder IDs of all folders in Test Lab, use the following SQL:

    SELECT *
    FROM CYCL_FOLD /*Test Set Folder (CYCLE)*/

    If you know the name of the folder that you want to select data from, and need the folder ID, try:

    SELECT *
    FROM CYCL_FOLD /*Test Set Folder (CYCLE)*/
    WHERE CF_ITEM_NAME = 'Folder Name Goes Here'

    Run it in test mode to get the folder path ID from the Results Pane, and use that folder path in the next query:

    SELECT
    CYCL_FOLD.CF_ITEM_ID as "Folder ID",
    CYCL_FOLD.CF_ITEM_PATH AS "Folder Path",
    CYCL_FOLD.CF_ITEM_NAME as "Test Set Folder Name",
    CYCLE.CY_CYCLE_ID AS "Test Set ID",
    CYCLE.CY_CYCLE as "Test Set Name",
    TEST.TS_TEST_ID AS "Test Case ID",
    TEST.TS_NAME AS "Test Case Name",
    TESTCYCL.TC_TEST_ORDER AS "Test Case Order",
    TESTCYCL.TC_STATUS as "Test Case Status"

    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 JOIN TEST ON TEST.TS_TEST_ID = TESTCYCL.TC_TEST_ID

    WHERE
    CYCL_FOLD.CF_ITEM_PATH LIKE 'AAAAAOAAE%' /*Folder Path ID*/

    ORDER BY
    CF_ITEM_ID, CY_CYCLE_ID, TC_TEST_ORDER


    It's not as clean as it could be (it returns folders with no test sets, for example) but you should be able to easily filter out these empty folders in Excel. I just happen to like it showing empty folders so I can cross-check....


    I've added in and ordered it by test case order as well, so your results show up in the same order as in the execution grid.

  3. #3
    SQA Knight bklabel1's Avatar
    Join Date
    Sep 2012
    Location
    Kew Gardens, United States
    Posts
    2,596
    Post Thanks / Like
    Blog Entries
    1
    Mentioned
    2 Post(s)
    Tagged
    2 Thread(s)
    Total Downloaded
    0
    aeb,
    Maybe it is possible to do this through the ALM object model. Something such as test.run or test.results. Then there are methods and properties for sending results to the test lab area. I thought that I have seen code such as this in the past. Perhaps someone reading this knows more about this or has access to sample code.
    Thanks,
    Kevin

 

 

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 03:30 AM.

Copyright BetaSoft Inc.