Component Test cases export to Excel
Question ID: 105707
1
0

we would like to generate an excel document with our BP tests and their design steps. How can we do this?

Marked as spam
Posted by (Questions: 22, Answers: 1)
Asked on October 31, 2014 7:46 pm
56 views
Answers (1)
1
Private answer

Hello,

I think the easiest way to do this would be to create an excel report using the following query.

SELECT TEST.TS_TEST_ID as ''Test ID'', /*Test.Test ID*/
TEST.TS_NAME as ''Test Name'', /*Test.Test Name*/
TEST.TS_SUBJECT as ''Subject'',
TEST.TS_DESCRIPTION as ''Test Desc.'', /*Test.Description*/
TEST.TS_DEV_COMMENTS as ''Comments'',
TEST.TS_TYPE as ''Test Type'', /*Test.Type*/
COMPONENT_STEP.CS_STEP_NAME as ''Step Name'',
COMPONENT_STEP.CS_DESCRIPTION as ''Step Description'',
COMPONENT_STEP.CS_EXPECTED as ''Expected Results''

FROM ALL_LISTS
Left Join TEST on ALL_LISTS.AL_ITEM_ID=TEST.TS_SUBJECT
Left join BPTEST_TO_COMPONENTS on TEST.TS_TEST_ID=BPTEST_TO_COMPONENTS.BC_PARENT_ID
Left join COMPONENT_STEP on BPTEST_TO_COMPONENTS.BC_CO_ID=COMPONENT_STEP.CS_COMPONENT_ID

WHERE
BC_PARENT_ID = TS_TEST_ID
AND AL_ITEM_ID = TS_SUBJECT
AND TS_SUBJECT = ALL_LISTS.AL_ITEM_ID
ORDER BY TS_TEST_ID

Marked as spam
Posted by (Questions: 1, Answers: 69)
Answered on October 31, 2014 7:48 pm
EyeOnTesting

Welcome back to "EyeOnTesting" brought to you by Orasi Software, Inc.

X
Scroll to Top