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.
Comments
Ralph Schoon
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER Sep 16 '16, 10:42 a.m.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.
Flavio Peralta
Sep 16 '16, 11:16 a.m.Hi Ralph,