How to display test cases in the backlog hierarchy and on export to excel?

Question

We are after a solution that can export our test cases whilst maintaining the parent linkage to the Scenario in the hierarchy.

Here's what we have set up so far:

We have used the new Microsoft Business catalog Nov2024 to create a new ADO project.

The New business catalog uses Scenarios, which is one level deeper than User Stories.
We have created 350 Test cases and linked these test cases to Scenarios using the Parent link.

So you now have

User story as a Parent to Scenario as a parent to Test case.

Next, we wanted to export the backlog hierarchy into a NEW ADO project (test cases included).

To do this we create a query of the backlog hierarchy and then exported to excel.

We notice that the Test cases do not show in the backlog hierarchy view nor do they show in the export file.

How can we fix this so that the Test cases linked to the Scenarios show in the backlog hierarchy, show in the query of that backlog hierarchy, and in the subsequent export to excel file?

As a side note, we have created a separate query of scenarios and their linked test cases. Azure only exports this as a Flat list (not a tree view) with the Parent column displayed. When we published the list to a new ado, the scenario and test cases were created but NO linkage between Test case and Scenario came across.

We have also imported Test cases via test suites. Whilst the test cases and steps come across correctly, we have not been successful in bringing across the linkages of each test case to its Parent Scenario via this method.

Thanks

Answer 1

Hi Tracia Almeida,
If you are unable to see the Backlogs under the list, then you need to edit the Team Configuration under Project Settings to include the Backlogs test cases.

Can you please check Backlogs option under Boards section in Overview.

• Click on the 3 dots on the right corner top and select Create Query.
• Save the Query into a new folder.
• Navigate to the Queries section and open your Query.
• Now click on the 3 dots in the right top corner and select Export to CSV option.

---

Hope this Helps

If the answer is helpful, please click Accept Answer and kindly upvote it. If you have any further questions about this answer, please click Comment.