Exporting test steps from specific Parent and Child folders to Excel

  • Questions
  • Exporting test steps from specific Parent and Child folders to Excel
Question ID: 106588
0
0

I need help with exporting test steps from ALM to Excel. I am able to export all of the test steps from ALM to Excel, but I am wanting to only export a specific Parent folder along with all of tests locate in the Child folders. What is the query that I can use to do this?

Marked as spam
Posted by (Questions: 217, Answers: 21)
Asked on January 12, 2016 8:15 pm
27 views
Answers (1)
0
Private answer

I will be glad to assist you with this. I have entered a query below that will pull the tests from the Parent folder, as well as all of the Child folders located within. First, you will need to access Site Admin, locate and expand the project you are wanting to export the test steps from and select the ALL_LISTS table. Next, record the value displayed in the AL_ABSOLUTE_PATH column for the parent folder.
Note: You will need to make sure to add the '%' after the AL_ABSOLUTE_PATH value to pull the child folders.

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_ABSOLUTH_PATH LIKE '<<>>'
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: 278)
Answered on January 12, 2016 8:17 pm