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?
Answer by jameslcoleman · Jan 12, 2016 at 08:17 PM
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 '<<<Absolute Path Value%>>>' 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