Answer by Josh_Yates · Aug 15, 2014 at 03:10 PM
This can only be done on manual BPT steps and it is possible to bring the tests into excel along with their steps.
You could export the BPT tests into excel using this query in an excel report from the dashboard, see what I have below:
NOTE: You will need to change the "Folder Name" value in this line AND AL_DESCRIPTION Like '%Folder Name%' to the value of the name of the folder in the test plan that contains the tests (This needs to be the folder directly above the tests that you are wanting to export, the direct parent folder of the tests)
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
NOTE: This will not work on flows only on straight BPT tests, you would need to re write the code to work with flows
ALM - Excel Add-In URL attachment 1 Answer