Excel Add-In allows users to export one type at a time. So, if you generate query in Excel Add-In you will need to create 3 distinct queries - Portfolio Item Feature, User Stories and Tasks and then merge data together.
To get three levels of "type" in one query download the Custom List with Deep Export which is available in the App Catalog. Your data will extract rows as follows:
- F1234 with columns (e.g. data elements from feature type)
- F1234 US5678 with columns (e.g. data elements from user story type)
- F1234 US5678 TA9000 with columns (e.g. data elements from task type)
Caveats: 1) you must place filters on the data; for example by timeboxes (release or iterations), owner, etc. Otherwise, query will pull all data from beginning of time, 2) You can extract data from each type - feature (e.g. planned start/end dates), user story (plan estimates, acceptance criteria, etc.) and task level (state, actual hours, to do hours, etc.). Therefore, you should limit the number of columns which add to query. More columns means slower response time, 3) Query works well with Chrome or Firefox. IE just doesn't work; slow response time which results in an error message.
Original Message:
Sent: 06-19-2019 07:48 PM
From: Ashok Rajamal
Subject: Rally Export
Would it be possible to export data from Rally to get the following data?
Portfolio
User Story
BA Planned hours
Dev Planned hours
QA Planned hours
Task name
Task Estimated
Task To do