Export query of work item with children links
Hi everyone,
I'm trying to export the results of a query that shows information of about 2250 work items and includes the children link as column but the generated csv is truncated. I mean, i.e., the csv shows only 2057 rows and the last one has the information on the first half columns. If I run the query without the children links and export it, the csv is generated correctly. BTW I'm using RTC 4.0.6.
Does someone know if there is some configuration that can fix this?
|
Accepted answer
Per my experience, if there's any issue or mis-configuration with the child work items the export may fail.
You said "If I run the query without the children links and export it, the csv is generated correctly." From this operation, you can find out which work item is exported after workitem "55279".
Then build a query and test whether you can export workitem "55279" and the worktiem after it which child links successfully. If the exporting fails, you need to further check if any mis-configuration in the child work items.
Flavio Peralta selected this answer as the correct answer
Comments
Flavio Peralta
commented Sep 20 '16, 8:29 a.m.
Lily, thanks so much! You are right. The problem was on one work item after the last one exported (55279) that had a corrupted child link. |
Your answer
Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.
Comments
What client are you using? Web, Eclipse?
Please be aware that for some list type objects the CSV export uses cr+lf (line break), so that one table line of the CSV could be spread across multiple lines. So if you open them with a text editor you would get even more lines. So what kind of editor do u use to open the CSV file?
Just limit the query to one work item with several children to understand how the CSV would look like.
Hi Ralph,