where do you want to export? what format? or do you need to copy to another proyect?

regards

The export (excel file with CSV format) will be used to import to another test tool.

tests cases and each steps are not a problem, with  a sql could be easy to do. the main probem or question are the attachment files.  for download them, you will need use a api rest or ota api and a custom development

So any ALM admin could take the report of test cases + steps with an SQL? 

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)

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)