I am using Rally excel add-in and trying to retrieve User Stories and associated Test Cases. I added additional column to the report "User Story" to retrieve TestCase.Name and also tried TestCase.FormattedID. In both cases I receive empty column. What am I doing wrong? Also there is a column "Number of Test Cases" that also always returns nothing.
相关问题
- Excel Add In - Where does console.log output it
- How to copy range formatting in office.js?
- Excel JS Add-In works in Excel but not Excel Onlin
- Add items to the ROT( Running Objects Table)
- Add excel custom functions to an existing excel ad
相关文章
- Add excel custom functions to an existing excel ad
- How to keep reference to add-in UDF when workbook
- VSTO Debug version fine, Installed version doesn
- Invalid Hyperlink: Malformed URI is embedded as a
- Data for calculating Vellocity Chart in Rally [dup
- Rally grid with custom column renderer sort
- Filtering epics from Kanban board
- How to Add an Attachment to a User Story using Ral
Here is a custom app that builds a grid of user stories and associated test cases. Looks like this is the data you want to display:
The code is available in this git hub repo. You may copy/paste the html file into a custom page.
If you prefer to filter by Releases, not Iterations, you may change
scopeType
ofRally.app.TimeboxScopedApp
As far as Excel addin, I do not see a column available on a User Story query that would display test cases associated with a story. Since TestCases is a collection on HierarchicalRequirement object in WS API a separate query has to be made to get to individual Test Cases. That's what I did in the code above.
Here is a screenshot from my Excel plugin. There is TestCaseStatus, which is expected, but TestCases collection is not included since the collection will only return a uri. Perhaps you are using a custom tool to export from Rally to Excel.
Use TestCases.FormattedID, it will give all linked test cases in single cell separated by comma.