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

book

Article ID: 101637

calendar_today

Updated On:

Products

CA OPS/MVS Event Management & Automation CA Agile Central On Premise (Rally) CA Agile Central SaaS (Rally)

Issue/Introduction



How can we use the Excel add-in to export only Defects that are connected with User Stories along with their User Stories?

Environment

Release:
Component: ACSAAS

Resolution

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:

<Please see attached file for image>

User-added image


To export the User Story FormattedID, you can use this query:

<Please see attached file for image>

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

Attachments

1558701012017000101637_sktwi1f5rjvs16kda.png get_app
1558701010071000101637_sktwi1f5rjvs16kd9.png get_app