Agile Central: Excel - How to export Defects along with their User Stories

Document ID : KB000101637
Last Modified Date : 15/06/2018
Show Technical Document Details
Question:
How can we use the Excel add-in to export only Defects that are connected with User Stories along with their User Stories?
Answer:
The Defect field that holds the User Story reference is: "Requirement". 

If exported as-is , it will export the User Story's Name
This is an example of filtering defects that are linked with user stories , then exporting the user stories' names:
User-added image


To export the User Story FormattedID, you can use this query:
User-added image
Additional Information:
More information on the Excel Add-in: 
https://help.rallydev.com/import-export-excel-addin

Excel Add-in's installation guide:
https://help.rallydev.com/rally-add-excel-installation-user-guide

Additional Knowledge Articles on the Excel Add-in:
https://support.ca.com/us/product-information/ca-agile-central.html?q=excel&type=ALL