QC: Get folder structure with test set and cases along with their pass or fail status

I need some directions on how to approach this…

I have a folder structure in QC like the one I attached in this screenshot:

I want the result in below format

All along I have been using the cross filter in standard report using Test Instance type. I was able to get the TestSetName, Test cases, Pass or Fail and the custom JIRA Defect ID field but I do not know how to get the folder structure there.

Can anyone give me any directions, please?

Answer

I wrote a little program to export the test hierarchy as a CSV file including an optional list of TSTest values. You can get the code from: https://github.com/thearttrooper/ota.git. The program accounts for hierarchies where the TSTest leaves are not all at the same depth. It’ll pad shallow hierarchies so that the leaf values all start in the right place. When exporting a TSTest property, you specify the user label of the property, not the DB column name. For example you use “Status”, not TS_STATUS.