Help with a query that is creating duplicates in my ALM reports.

Question ID: 109280
1
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 (Questions: 205, Answers: 14)
Asked on February 5, 2020 10:35 am
15 views
Answers
1
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 (Questions: 2, Answers: 266)
Answered on February 5, 2020 10:36 am