Issue with attribute value with csv export in RTC
Hello,
I have created an attribute type called "Project Name" of "Work Item" type in a work item. This Project Name attribute is a searchable to add the work item.
When we run a query and display this "Project Name" field as a column , the out put is "Project Id: Summary" format.
But when i export the same query out put to csv file , the Project Name Column only diaplying "Project Id" alone not the summary along with it.
Do we have some work around to get summary also to export. This is important for us to display the summary also for reporting purpose.
Kindly suggest some work around on this issue...if possible.
Thank You Very Much....in advance..!
I have created an attribute type called "Project Name" of "Work Item" type in a work item. This Project Name attribute is a searchable to add the work item.
When we run a query and display this "Project Name" field as a column , the out put is "Project Id: Summary" format.
But when i export the same query out put to csv file , the Project Name Column only diaplying "Project Id" alone not the summary along with it.
Do we have some work around to get summary also to export. This is important for us to display the summary also for reporting purpose.
Kindly suggest some work around on this issue...if possible.
Thank You Very Much....in advance..!
One answer
Hi Aswath,
Please add the column into the export query.
Select the work item attributes to display as column headings in the output. By default, the columns that are specified on the query editor Column Display page are used. You can modify the default selections to customize the resulting output.
https://www-01.ibm.com/support/knowledgecenter/SSYMRC_5.0.2/com.ibm.team.workitem.doc/topics/t_exporting_work_items.html?lang=en
Regards,
Arun.
Please add the column into the export query.
Select the work item attributes to display as column headings in the output. By default, the columns that are specified on the query editor Column Display page are used. You can modify the default selections to customize the resulting output.
https://www-01.ibm.com/support/knowledgecenter/SSYMRC_5.0.2/com.ibm.team.workitem.doc/topics/t_exporting_work_items.html?lang=en
Regards,
Arun.
Comments
Hello Arun,
Thanks for your inputs. i have tried exporting the attribute value using "Internal Value" instead "Label". But still the column attribute of type "Work item list " is displaying the #Unique Id (like #42) of Work item in csv export column value not with complete summary.
This is an issue must be...with csv export.Is there any thing else we can look at.
Thank you...!