SPONSORS:






User Tag List

Thanks Thanks:  0
Likes Likes:  0
Dislikes Dislikes:  0
Results 1 to 7 of 7
  1. #1
    Member
    Join Date
    Feb 2007
    Location
    London
    Posts
    391
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Can you retrieve test results stored in QC?

    I'm in the very early stages of writing some code that will go and interrogate the test results that are stored in QC, so I'm trying to figure out the logic on how to do this.

    From what I can see, the xml results file is saved in the repository on the QC server. This is the file I want to interrogate. This isn't saved in any logical structure, e.g. the last run was saved under "C:\program files\xyz...\1873\3968_45641\Report\" so I presume I have to find out the location of the report from quality center?

    If so, how can I obtain path of the report from quality center? Should I:

    i) Use SQL to obtain the path directly from the SQL server
    ii) Use the QC API to find this out

    or are there any other suggestions on how to achieve this?

    Many thanks

    Dave

  2. #2
    Moderator
    Join Date
    Jul 2005
    Location
    Delhi
    Posts
    15,575
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    7 Thread(s)
    Total Downloaded
    0

    Re: Can you retrieve test results stored in QC?

    You need to look into the Run using the RunFactory for that test in testlab. Once you get the Run you need to use extendedStorage and download all the file contents from the same.

  3. #3
    SQA Knight
    Join Date
    Jun 2008
    Posts
    2,555
    Post Thanks / Like
    Mentioned
    3 Post(s)
    Tagged
    1 Thread(s)
    Total Downloaded
    0

    Re: Can you retrieve test results stored in QC?

    Also note that the extendedstorage object requires special permission from the QC admin in order to access.

  4. #4
    Member
    Join Date
    Feb 2007
    Location
    Irvine, CA USA
    Posts
    89
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: Can you retrieve test results stored in QC?

    Tarun/NoUse4aName,

    Guys, can you please expound more on this?

    Thanks.

  5. #5
    Super Member Jonty's Avatar
    Join Date
    Jan 2007
    Location
    India
    Posts
    1,266
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: Can you retrieve test results stored in QC?

    QC forum is place where one can find examples on how to use extended storage and OTA.
    Cheers
    Jonty..
    -- Here to Learn and share ---

  6. #6
    Member
    Join Date
    Feb 2007
    Location
    London
    Posts
    391
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: Can you retrieve test results stored in QC?

    Thanks for the pointers guys - I'm assuming RunFactory and extendedStorage are parts of the QC API, it's been over a year since I worked with this but I'll look into it.

    I've also been digging around in the QC database - it appears that the tables dbo.testcycl and dbo.run also contain a lot of run information which can be used to find out where the result files are saved. It may be quicker than using the API but means I'll have to dust off my SQL book and get writing some queries. If I come up with any useful queries I'll share them here.

  7. #7
    Member
    Join Date
    Feb 2007
    Location
    London
    Posts
    391
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: Can you retrieve test results stored in QC?

    This seems to be a good starting point - in this example I'm trying to query all of the test results for a given timeframe.

    The TS_PATH and RN_PATH displayed can be used to obtain the path to the results set in the repository on the server.

    This approach has the dependency that you have permissions to access the repository to obtain the xml file, which is fine where I work but may not be suitable for larger organisations where more stringent security is in place!

    SELECT tTest.TS_NAME, tTest.TS_PATH, tTest.TS_TYPE, tRun.RN_TEST_ID,tRun.RN_PATH , tRun.RN_EXECUTION_DATE, tRun.RN_EXECUTION_TIME
    FROM <DBNAME>.dbo.run tRun, <DBNAME>.TEST tTest
    Where tRun.RN_TEST_ID = tTest.TS_TEST_ID AND
    tTest.TS_TYPE = 'QUICKTEST_TEST' AND
    RN_EXECUTION_DATE >= '2010-06-02 00:00:00.000' AND
    RN_EXECUTION_DATE <= '2010-06-08 00:00:00.000'
    Order by RN_EXECUTION_DATE Asc

 

 

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 10.00%
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 01:43 AM.

Copyright BetaSoft Inc.