Report of the latest test steps that have failed

Question ID: 109175
0
0

Hello. We are wanting to generate a report containing the latest test steps that have failed. Could you please provide a query that will create an excel report containing the latest test steps have failed? I appreciate your help with this.

Marked as spam
Posted by (Questions: 204, Answers: 14)
Asked on September 12, 2019 7:38 pm
2 views
Answers
0
Private answer

Hello. I believe I have a query that will produce the results you are looking for. You will need to locate the value in the 'CF_ITEM_PATH' field within the 'CYCL_FOLD' table for the Test Plan folder where the target tests are located. You will need to place the 'CF_ITEM_PATH' value into the following line of script - WHERE CF_ITEM_PATH = 'AAAAAH'. Test the query in your test environment and let me know what you think. If you need anything else regarding this case, please let me know.

Before using the query to create a report in the Analysis Module, you will need to make sure the ENABLE_CREATE_LEGACY_EXCEL_REPORT parameter has been added to the 'Site Configuration' tab in Site Admin. The value for the parameter will need to be set to 'Y'. After you have either verified that the parameter already exists, or added the parameter, you will access the 'Analysis View', click the 'New Item' (Green plus symbol) drop down arrow, and select 'New Excel Report' from the menu that displays. Enter the name for the Excel report and click the 'OK' button. In the 'Configuration' / 'Query' tab, you will need to enter the query that I provided (Remember to change the folder name value in the query to reflect the folder you wish to export). Click the 'Generate' button, then 'Yes' in the 'Confirm' window that displays. Select the file name and save location and click the 'Save' button. The Excel report should open with the extracted data displayed.

SELECT
TS_TEST_ID As 'Test ID',
RN_RUN_ID As 'Run ID',
TS_NAME As 'Test Case Name',
ST_STEP_NAME As 'Test Step Name',
ST_DESCRIPTION As 'Test Step Description',
ST_EXECUTION_DATE As 'Execution Date',
ST_EXECUTION_TIME As 'Execution Time',
ST_STATUS As 'Test Step Status'
FROM TESTCYCL
LEFT OUTER JOIN RUN ON RN_RUN_ID = (SELECT MAX(RN_RUN_ID) FROM RUN WHERE RN_TESTCYCL_ID = TC_TESTCYCL_ID)
AND (SELECT COUNT(RN_RUN_ID) FROM RUN WHERE RN_TESTCYCL_ID = TC_TESTCYCL_ID) > =1
INNER JOIN STEP ON ST_RUN_ID = RN_RUN_ID
INNER JOIN TEST ON TC_TEST_ID = TS_TEST_ID
INNER JOIN CYCLE ON TC_CYCLE_ID = CY_CYCLE_ID
INNER JOIN CYCL_FOLD ON CF_ITEM_ID = CY_FOLDER_ID
WHERE CF_ITEM_PATH = 'AAAAAH'
AND ST_STATUS = 'Failed'
GROUP BY TS_NAME, RN_STATUS, TC_STATUS, TS_TEST_ID, ST_STATUS, RN_RUN_ID, ST_STEP_NAME, ST_DESCRIPTION,
ST_EXECUTION_DATE, ST_EXECUTION_TIME

Marked as spam
Posted by (Questions: 2, Answers: 265)
Answered on September 12, 2019 7:39 pm