The online community for software testing & quality assurance professionals
 
 
Calendar   Today's Topics
Sponsors:




Lost Password?

Home
BetaSoft
Blogs
Jobs
Training
News
Links
Downloads



Testing Tools >> HP ALM / Mercury Quality Center

michaeltewierik
Member


Reged: 08/11/08
Posts: 116
Re: How to export tests from QC to excel
      02/28/10 04:37 PM

The following can be used in Excel Report generator.

Replace "myPath" with a string similar to 'AAAAAPAAFAAB%' to get the specific parent folder. You will need to check for your specific source Parent in the All_Lists table so that you have the correct path string as there could be multiple folders with the same name!
Step names are sometimes the same as well (within the same script!) and can throw out your actual step order the "order by" is required to use test id and step order to give correct order to the returned items.

SELECT
TS_TEST_ID as Test_ID,
TS_NAME as Name,
AL_DESCRIPTION as Folder,
TS_DESCRIPTION as Description,
DS_STEP_NAME as Step_Name,
DS_DESCRIPTION as Step_Description,
DS_EXPECTED as Expected_Result,
DS_STEP_ORDER as Step_Order
FROM
TEST
INNER JOIN
DESSTEPS ON DS_TEST_ID = TS_TEST_ID
INNER JOIN
ALL_LISTS ON AL_ITEM_ID = TS_SUBJECT
WHERE
AL_ITEM_ID in (SELECT ALL_LISTS.AL_ITEM_ID from ALL_LISTS where AL_ABSOLUTE_PATH like 'myPath')
ORDER BY
TS_TEST_ID, DS_STEP_ORDER

Post Extras Print Post   Remind Me!     Notify Moderator


Entire topic
Subject Posted by Posted on
* How to export tests from QC to excel nikki_qa 11/18/07 06:05 AM
. * * Re: How to export tests from QC to excel 03471A0227   05/08/12 12:04 PM
. * * Re: How to export tests from QC to excel proximityinfo   06/24/10 01:01 AM
. * * Re: How to export tests from QC to excel Syaman   01/10/08 07:03 AM
. * * Re: How to export tests from QC to excel Tony Davis   01/10/08 09:21 AM
. * * Re: How to export tests from QC to excel Cuthbert   01/10/08 01:16 PM
. * * Re: How to export tests from QC to excel Syaman   01/11/08 02:49 AM
. * * Re: How to export tests from QC to excel Ronaldo121   03/17/08 06:04 AM
. * * Re: How to export tests from QC to excel AuradisWorld   03/23/12 08:50 PM
. * * Re: How to export tests from QC to excel Syaman   03/21/08 07:36 AM
. * * Re: How to export tests from QC to excel jirlbeck   01/12/11 07:39 AM
. * * Re: How to export tests from QC to excel qa_answer_seeker   08/12/10 07:23 PM
. * * Re: How to export tests from QC to excel arkay15   08/16/10 05:38 PM
. * * Re: How to export tests from QC to excel MrAnonGuy   03/18/08 09:08 AM
. * * Re: How to export tests from QC to excel arkay15   08/18/10 06:24 PM
. * * Re: How to export tests from QC to excel Syaman   01/11/08 05:28 AM
. * * Re: How to export tests from QC to excel Venugajendra   02/15/08 06:16 AM
. * * Re: How to export tests from QC to excel Syaman   03/21/08 08:03 AM
. * * Re: How to export tests from QC to excel lisapayneabreu   07/30/08 11:40 AM
. * * Re: How to export tests from QC to excel kushwaaj   02/08/10 01:01 AM
. * * Re: How to export tests from QC to excel Syaman   01/11/08 05:29 AM
. * * Re: How to export tests from QC to excel itssri   01/11/08 01:17 PM
. * * Re: How to export tests from QC to excel ambience   01/14/08 02:28 PM
. * * Re: How to export tests from excel to qc Saaz   01/15/08 09:54 PM
. * * Re: How to export tests from excel to qc Saaz   01/21/08 12:51 AM
. * * Re: How to export tests from excel to qc dovi   01/21/08 02:58 AM
. * * Re: How to export tests from qc to excel Saaz   01/21/08 03:06 AM
. * * Re: How to export tests from excel to qc dovi   01/21/08 03:09 AM
. * * Re: How to export tests from qc to excel Saaz   01/21/08 03:36 AM
. * * Re: How to export tests from excel to qc dovi   01/21/08 03:45 AM
. * * Re: How to export tests from excel to qc dovi   01/21/08 03:47 AM
. * * Re: How to export tests from qc to excel Saaz   01/21/08 04:03 AM
. * * Re: How to export tests from QC to excel Syaman   01/15/08 08:10 AM
. * * Re: How to export tests from QC to excel ambience   01/21/08 08:41 AM
. * * Re: How to export tests from QC to excel Amulyaraag   01/19/11 05:27 PM
. * * Re: How to export tests from QC to excel biggi   05/26/10 02:54 PM
. * * Re: How to export tests from QC to excel genevish   05/24/10 01:35 PM
. * * Re: How to export tests from QC to excel Syaman   03/21/08 07:02 AM
. * * Re: How to export tests from QC to excel wjones   02/23/10 11:08 AM
. * * Re: How to export tests from QC to excel wjones   02/23/10 11:59 AM
. * * Re: How to export tests from QC to excel suny10   02/24/10 09:05 PM
. * * Re: How to export tests from QC to excel Jonty   02/25/10 12:20 AM
. * * Re: How to export tests from QC to excel -Asher-   02/25/10 12:34 PM
. * * Re: How to export tests from QC to excel -Asher-   03/01/10 07:34 PM
. * * Re: How to export tests from QC to excel BigSimmo   02/17/11 02:06 PM
. * * Re: How to export tests from QC to excel -Asher-   02/17/11 06:59 PM
. * * Re: How to export tests from QC to excel rmcginnis   02/25/10 02:38 PM
. * * Re: How to export tests from QC to excel suny10   02/25/10 08:20 PM
. * * Re: How to export tests from QC to excel michaeltewierik   02/28/10 04:37 PM
. * * Re: How to export tests from QC to excel Tammi   06/23/10 06:25 AM
. * * Re: How to export tests from QC to excel jnlp   05/24/10 01:33 AM
. * * Re: How to export tests from QC to excel Blue_Motorcycle   02/07/08 12:32 PM
. * * Re: How to export tests from QC to excel Saaz   02/07/08 04:17 AM
. * * Re: How to export tests from QC to excel Tony Davis   02/07/08 06:52 AM
. * * Re: How to export tests from QC to excel Saaz   01/21/08 11:06 PM

Extra information
0 registered and 17 anonymous users are browsing this forum.

Moderator:  Rich W., AJ, jgottlieb 



Forum Permissions
      You cannot start new topics
      You cannot reply to topics
      HTML is disabled
      UBBCode is enabled

Rating:
Thread views: 47477

Rate this thread

Jump to

Contact Us | Privacy statement SQAForums

Powered by UBB.threads™ 6.5.5