How to export the test cases from QC

  • Questions
  • How to export the test cases from QC
Question ID: 106821
1
0

We would like to export all the test cases from the QC including the steps and summary .
Can you please suggest the steps for the same.

Marked as spam
Posted by (Questions: 199, Answers: 1)
Asked on April 29, 2016 2:10 pm
32 views
Answers (3)
1
Private answer

I am attaching a zip file that contains 2 documents describing how to create the report of Test Cases with Design Steps as well as a Query to [produce the Report for][1] downloading to Excel.

Here is the basic procedure:
1. From the Test Plan Module, click Analysis->Reports->Tests with Design Steps
2. This will provide a preview of all the tests in the Test Plan for your review. You can then click the save icon and determine what type of format you would like the report in and where to save it.
For the query needed for an Excel Report see the 2nd attachment.![alt text][2]

[1]: /storage/temp/439-here-are-the-steps-to-create-a-tests-with-design-s.zip
[2]: /storage/temp/440-queryfortestdesignstepsreport.png

Marked as spam
Posted by (Questions: 1, Answers: 213)
Answered on April 29, 2016 2:20 pm
In the above SQL Query, i want to know what is the exact expected value required in Absolute Path if i have folder structure in Test Plan as Subject >> Release Name >> Cycle Name >> Project Name ---> Test Cases
( at September 16, 2017 7:43 am)
0
Private answer

In the above SQL Query, i want to know what is the exact expected value required in Absolute Path if i have folder structure in Test Plan as
Subject >> Release Name >> Cycle Name >> Project Name ---> Test Cases

Marked as spam
Posted by (Questions: 0, Answers: 2)
Answered on September 16, 2017 7:43 am
0
Private answer

BMG,
The WHERE clause in the above query states
'WHERE A.AL_ITEM_ID=TS_SUBJECT AND A.AL_ABSOLUTE_PATH LIKE 'AAAAAP%'

the LIKE 'AAAAAP%' includes the wildcard character '%' and the 'AAAAAP' happens to be what is returned for the absolute path of the Subject root directory so by including the wildcard character '%' the query will return all of the subdirectories of the Subject folder. In the above example, the absolute path is not being displayed but when you actually execute the query, you would see the absolute path of all the subdirectories.

Marked as spam
Posted by (Questions: 1, Answers: 213)
Answered on September 18, 2017 4:19 pm