Excel report containing both the calling tests test steps and the called tests test steps

  • Questions
  • Excel report containing both the calling tests test steps and the called tests test steps
Question ID: 108005
0
0

I would like to get a report from ALM that contains both the steps of the calling tests and the called tests from a specified folder. I would like the called test steps displayed within the calling test steps in the report, in the order they are displayed in Test Plan. I would also like to add that the calling tests are in a separate folder than the called tests. Will this be possible to do?

Marked as spam
Posted by (Questions: 230, Answers: 30)
Asked on November 9, 2017 9:36 pm
10 views
Answers (1)
0
Private answer

Hello. I have entered the query below that will pull the tests with called test steps from the folder specified in Test Plan. The called test steps will be displayed within the calling test steps in the report, in the same order they are displayed in Test Plan. You will need to create a 'New Excel Report' within the Analysis module, then enter the script below into the 'Configuration' tab. If the 'New Excel Report' option isn't available in the Analysis module, then you will need to add the 'ENABLE_CREATE_LEGACY_EXCEL_REPORT' parameter into the 'Site Configuration' tab within Site Admin, and set the value field to 'Y'. I hope this helps.

SELECT
TS.TS_TEST_ID As 'Test ID',
TS.TS_NAME As 'Test Name',
TS.TS_RESPONSIBLE As 'Tester',
DS.DS_STEP_ORDER As 'Step Number',
DS.DS_STEP_NAME As 'Step Name',

CASE
WHEN DS.DS_LINK_TEST is NULL
THEN DS.DS_DESCRIPTION
ELSE DS_LN.DS_DESCRIPTION
END
'Step Description',

CASE
WHEN DS.DS_LINK_TEST is NULL
THEN DS.DS_EXPECTED
ELSE DS_LN.DS_EXPECTED
END
'Expected Result'

FROM DESSTEPS DS
LEFT JOIN DESSTEPS DS_LN ON DS_LN.DS_TEST_ID = DS.DS_LINK_TEST
JOIN TEST TS ON DS.DS_TEST_ID = TS.TS_TEST_ID
JOIN ALL_LISTS AL ON TS.TS_SUBJECT = AL.AL_ITEM_ID
AND AL.AL_DESCRIPTION = '<>'
ORDER BY TS.TS_TEST_ID, DS.DS_STEP_ORDER, DS.DS_STEP_NAME

Marked as spam
Posted by (Questions: 2, Answers: 292)
Answered on November 9, 2017 9:37 pm