Help with a query that is creating duplicates in my ALM reports.
| ♥ 1 |
Hello. I have been asked to create a report for a team that will provide the test cases along with the “Actual” results from all the test cases that have been run. I was able to pull together all the data, but I’m stuck with narrowing down the info to one line per test case. If it was just the test case info, I could export it from the module, but I need the “actual” result notes from the test lab and that’s causing me to get duplicating lines per test case. Is there a way to narrow it down? SELECT STEP.ST_STEP_NAME as ‘Test Name’, STEP.ST_DESCRIPTION as ‘Test Description’, STEP.ST_ACTUAL as ‘Actual Results’, TEST.TS_EXEC_STATUS as ‘Status’, TEST.TS_USER_05 as ‘Responsible Tester’, STEP.ST_EXECUTION_DATE as ‘Execution Date’, STEP.ST_RUN_ID, CYCLE.CY_CYCLE FROM STEP, TEST, CYCLE Where CY_CYCLE like ‘Vacation/Holiday Project – Data%’ and ST_RUN_ID > ‘469’
Marked as spam
|
Posted by |
Private answer
Hello. Give the following query a try. It will provide you with the correct amount of records in the report, including the ‘Actual’ results for each test. You may or may not want to edit some of the columns that display in the spreadsheet. If you need any further assistance with the query, please let me know.
SELECT TS_NAME As 'Test Name', ST_DESCRIPTION As 'Step Description', ST_ACTUAL As 'Actual Result', ST_EXECUTION_DATE As 'Step Exec Date', RN_STATUS As 'Run Status', RN_TESTER_NAME As 'Run Tester', TS_USER_05 As 'Tester' FROM CYCLE, TEST, STEP, RUN WHERE CY_CYCLE = 'Vacation/Holiday Project - Data' And ST_RUN_ID = '469' And CY_CYCLE_ID = RN_CYCLE_ID And RN_TEST_ID = TS_TEST_ID And RN_RUN_ID = ST_RUN_ID Marked as spam
 Posted by jameslcoleman (Questions: 2, Answers: 300) Answered on February 5, 2020 10:36 am
|