I didn’t quite expect to be using ALM. But anyways, putting my notes here just in case I ever have to revisit this again.
- Download and install the connectivity tool from ALM Tools.
- In Dashboard > Analysis view, add a New Excel Report.
- Using the Query Builder, figure out the query you can use.
- Generate the report.
Query: Test cases and test steps under a folder
You’ll need to search ALL_LISTS for the corresponding folder so that you can specify the correct one in the WHERE condition. It doesn’t preserve the folder tree structure though.
SELECT TEST.TS_SUBJECT, ALL_LISTS.AL_DESCRIPTION as "Folder Name", TEST.TS_TEST_ID as "Test ID", TEST.TS_NAME as "Test Name", TEST.TS_DESCRIPTION as "Test Description", DESSTEPS.DS_STEP_ORDER as "Step Order", DESSTEPS.DS_STEP_NAME as "Step Name", DESSTEPS.DS_DESCRIPTION as "Step Description", DESSTEPS.DS_EXPECTED as "Expected Results", TEST.TS_RESPONSIBLE as "Designer" FROM TEST JOIN ALL_LISTS on TEST.TS_SUBJECT = ALL_LISTS.AL_ITEM_ID JOIN DESSTEPS on TEST.TS_TEST_ID=DESSTEPS.DS_TEST_ID WHERE All_LISTS.AL_ABSOLUTE_PATH like'AAAAAPAAGBCIAAAAAAAAAAAC%' ORDER BY TEST.TS_SUBJECT, TEST.TS_TEST_ID, DESSTEPS.DS_STEP_ORDER