Export test steps from specified folder in Test Plan to Excel report
Question ID: 106576
0
0

I need help with exporting test steps from ALM to Excel. The query that I am currently using in the Analysis View within the Dashboard module pulls all of the test steps from test plan. I am wanting to pull the steps from a certain folder. Is there a way to pull the test steps from a specific folder and export them to Excel? I appreciate your help with this.

Marked as spam
Posted by (Questions: 239, Answers: 31)
Asked on January 7, 2016 10:04 pm
423 views
Answers (1)
0
Private answer

I will be glad to assist you with this. You will need to place a filter in your SQL query so that it pulls the test steps from a certain folder. I have placed a sample query below. You will need to edit to meet your specific needs. I hope this helps.

SELECT TS_NAME, TS_TEST_ID, TS_DESCRIPTION, TS_STEPS, DS_STEP_NAME, DS_DESCRIPTION, DS_EXPECTED
FROM TEST, DESSTEPS, ALL_LISTS
WHERE ALL_LISTS.AL_DESCRIPTION = 'Folder Name' AND TS_SUBJECT = ALL_LISTS.AL_ITEM_ID AND TS_SUBJECT = ALL_LISTS.AL_ITEM_ID AND TS_TEST_ID = DS_TEST_ID
ORDER BY TS_TEST_ID ASC, len(DS_STEP_NAME), DS_STEP_NAME

Marked as spam
Posted by (Questions: 2, Answers: 300)
Answered on January 7, 2016 10:07 pm
EyeOnTesting

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

X
Scroll to Top