IBM Support

Saving query outcome to CSV results in no names for linked work items

Troubleshooting


Problem

Attempts to saving work item query results in IBM Rational Team Concert (RTC) to CSV file, results with a file that has no names for linked work items (only work item IDs are being shown).

Symptom

You only see work item IDs.

Steps to reproduce

The following steps reproduces the results in RTC web UI.

  1. Create a query.

  2. Add new column Children under the Column Display tab.

  3. Add a unique name to the query and save it.

  4. Run the query.

  5. Use the Download as spreadsheet (csv.) button on the right left corner of the Conditions section.



The results file does not contains names/links of children work items as in the screen capture.




Cause

The Children column are references to potentially multiple elements.

Resolving The Problem

It is working as designed.

The exported CSV file contains only the IDs of related items. By design you can export multiple entires.

[{"Product":{"code":"SSUC3U","label":"IBM Engineering Workflow Management"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Work Items","Platform":[{"code":"PF033","label":"Windows"},{"code":"PF016","label":"Linux"}],"Version":"3.0.1;3.0.1.1;3.0.1.2;3.0.1.3;3.0.1.4;3.0.1.5;3.0.1.6;4.0;4.0.0.1;4.0.0.2;4.0.1;4.0.2;4.0.3","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]

Product Synonym

Rational Team Concert

Document Information

Modified date:
16 June 2018

UID

swg21648574