Possible to export test cases with test steps and attachments from ALM?

Are there any solution on how to export test cases with test steps & attachments in the cases from ALM? When we export to excel, we just get the test case title and no steps are included.

Parents Reply Children
  • 0 in reply to 

    without attachments, anyone with report permission can get all test cases with their own steps, just create a excel report with the next sql

    where the  "where PTH like '\Subject\%' is the path where you want to start getting testcases (leave like the code for full test cases.

    SELECT PTH, TEST.TS_TEST_ID , TEST.TS_NAME , TEST.TS_STATUS , TEST.TS_DESCRIPTION , TEST.TS_RESPONSIBLE ,  TEST.TS_CREATION_DATE,  DESSTEPS.DS_STEP_NAME, DESSTEPS.DS_DESCRIPTION, DESSTEPS.DS_EXPECTED
    
    --SELECT TEST.TS_TEST_ID
    FROM      TEST
    inner join
    (
    --SubQuery que devuelve el Test_ID y su Path
    SELECT PTH, TS_TEST_ID ID_TEST FROM
    (select AL_ITEM_ID, sys_connect_by_path(AL_DESCRIPTION, '\') PTH
    from ALL_LISTS connect by prior AL_ITEM_ID = AL_FATHER_ID
    start with AL_FATHER_ID = 0 and AL_DESCRIPTION = 'Subject')
    left join TEST on TS_SUBJECT = AL_ITEM_ID
    WHERE TS_TEST_ID IS NOT NULL
    ) on  TEST.TS_TEST_ID = ID_TEST
    
    inner join DESSTEPS on DESSTEPS.DS_TEST_ID = TEST.TS_TEST_ID
    
    --Ruta de donde se quieren sacar los CPU
    where PTH like '\Subject\%'
    
    order by pth

    this type of report is here, and if it not appearing, you need to enter the next site-amin parameter in the site-adminnistrator site.

    ENABLE_CREATE_LEGACY_EXCEL_REPORT to ‘Y’


    (you can find here: https://admhelp.microfocus.com/alm/api_refs/site_params/metadata.htm)