Test case Excel Download
Question ID: 108275
0
0

Hi team,

We need to download Test cases with Test Sets from ALM Test lab. Is there any script or Tool to assist that. Since there are more than 1000 Testcases under each folder we are unable to do manually. Requesting your assist here.

Marked as spam
Posted by (Questions: 204, Answers: 2)
Asked on April 25, 2018 8:22 pm
90 views
Answers (1)
0
Private answer

GoDawgs,
Here is the SQL Query you need:
SELECT
T.TS_TEST_ID, /*T.Test ID* /
T.TS_NAME, /*T.Test Name* /
T.TS_DESCRIPTION, /*T.Test Description * /
D.DS_STEP_NAME, /*Design Step.Step Name* /
D.DS_DESCRIPTION, /*Design Step.Step Description* /
D.DS_EXPECTED, /*Design Step.Expected Result*/
T.TS_TYPE, /*T.Type* /
A.AL_ABSOLUTE_PATH,
A.AL_DESCRIPTION /*Test Plan Folder.Name*/
FROM
ALL_LISTS A,
Test T
LEFT OUTER JOIN DESSTEPS D on TS_TEST_ID = D.TS_TEST_ID
WHERE
A.AL_ITEM_ID = T.TS_SUBJECT AND A.AL_DESCRIPTION LIKE'End2End%'

Marked as spam
Posted by (Questions: 1, Answers: 216)
Answered on April 25, 2018 8:23 pm
EyeOnTesting

Welcome back to "EyeOnTesting" brought to you by Orasi Software, Inc.

X
Scroll to Top