How to Export TestCases along with Design steps from HP QC/ALM

How to Export TestCases along with Design steps from HP QC/ALM

You can use ALM Excel reports (Analysis view –> Create new Excel Report)  to export test and design step data from QC/ALM to Excel sheet.  Use below query in Excel Report query builder.

 

**********************************************************************************************************************************************

 

SELECT

TEST.TS_TEST_ID as “Test ID”, /*Test.Test ID*/

TEST.TS_NAME as “Test Name”, /*Test.Test Name*/

TEST.TS_DESCRIPTION as “Test Desc.”, /*Test.Description*/

DESSTEPS.DS_STEP_NAME as “Step Name”, /*Design Step.Step Name*/

DESSTEPS.DS_DESCRIPTION as “Step Desc.”, /*Design Step.Description*/

DESSTEPS.DS_EXPECTED as “Expected Result”, /*Design Step.Expected Result*/

TEST.TS_STATUS as “Test Status”, /*Test.Status*/

TEST.TS_TYPE “Test Type”, /*Test.Type*/

TEST.TS_RESPONSIBLE as “Test Designer”, /*T ALL_LISTS.AL_ABSOLUTE_PATH /*Test Plan Folder.Absolute Path*/est.Designer*/

TEST.TS_USER_03 as “Test Priority”, /*Test.Priority*/

TEST.TS_USER_04 as “Test Reviewer”,

ALL_LISTS.AL_ITEM_ID as “SUBJECTID”,

ALL_LISTS.AL_DESCRIPTION as “SUBJECTPATH”

 

 

FROM

TEST,

DESSTEPS,

ALL_LISTS

WHERE

DS_TEST_ID = TS_TEST_ID and TEST.TS_SUBJECT = ALL_LISTS.AL_ITEM_ID and ALL_LISTS.AL_DESCRIPTION =’<< Replace Test Folder Name >>’

 

**********************************************************************************************************************************************

 

 

For the above query, it would be preference copy all the testcases to be exported in single temp folder in TestPlan module and replace Folder name in above query.

 

regards

Navneesh Garg

www.adactin.com