ALM report to display the test steps grouped by step status and actual tester

  • Questions
  • ALM report to display the test steps grouped by step status and actual tester
Question ID: 108660
0
0

Hello. We are in need of a report that will give us the test steps grouped by step status and the actual tester who ran the tests. There aren't any canned reports that give me this level of granularity. We would like all of the steps in test plan, broken down by month, as we run monthly reports for production, and this would be very helpful.

Marked as spam
Posted by (Questions: 204, Answers: 14)
Asked on October 19, 2018 2:23 pm
7 views
Answers
0
Private answer

I believe I have a query that will get the results you are looking for. If you have never created an Excel report from the Analysis View, you will need to perform the following steps in order to do so. To configure the Excel reporting, you will need to make sure that the ENABLE_CREATE_LEGACY_EXCEL_REPORT parameter has been added in Site Admin if you are using a version of ALM 12.0 and newer. Next, you will need to access the 'Analysis View' module. In the Analysis View module, click the drop down on the green plus button and select 'New Excel Report'. After you have named the excel report, enter the SQL query posted below into the Query1 text box and click 'Generate'. Select a save location for the excel report, click Save, and the excel report will open. If for some reason it doesn't open automatically, you can open from where it was saved.

SELECT
TEST.TS_NAME As 'Test Name',
TEST.TS_TEST_ID As 'Test ID',
TEST.TS_VTS As 'Date Modified',
TESTCYCL.TC_STATUS As 'Status',
TESTCYCL.TC_ACTUAL_TESTER As 'Tester',
DESSTEPS.DS_STEP_NAME As 'Step Name',
DESSTEPS.DS_DESCRIPTION As 'Step Description',
DESSTEPS.DS_EXPECTED As 'Expected Result'
FROM TEST
JOIN TESTCYCL ON TEST.TS_TEST_ID = TESTCYCL.TC_TEST_ID
JOIN DESSTEPS ON DESSTEPS.DS_TEST_ID = TEST.TS_TEST_ID
WHERE TEST.TS_VTS LIKE '2018-09%'
ORDER BY TEST.TS_VTS ASC

You will need to edit the month and year in the line WHERE TEST.TS_VTS LIKE '2018-09%' to pull the steps for the desired month.

Marked as spam
Posted by (Questions: 2, Answers: 265)
Answered on October 19, 2018 2:25 pm