ALM Query: Test cases and steps in a folder

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.

1. Download and install the connectivity tool from ALM Tools.
2. In Dashboard > Analysis view, add a New Excel Report.
3. Using the Query Builder, figure out the query you can use.
4. 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