It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Follow this question
Question details

×42,787
×11,924

question asked: Dec 02 '15, 12:39 p.m.
question was seen: 1,975 times
last updated: Dec 08 '15, 2:29 p.m.

Related questions

FAQ - How this Forum works

Is there a max size for export workitems in RTC Client into CSV?

1
Cesar Sasaki (511●2●85●126) | asked Dec 02 '15, 12:39 p.m.
 Hi
I have a query that has more than a 1000 rows, and I want to export it with my RTC Client,but when export it the CSV file only contains around 50 rows .

Any parameter that I need to change? is there a max character size?

Thanks in advance. 

One answer

Most liked answers ↑|Newest answers|Oldest answers

0
permanent link
Alexandre Stegani (866●4) | answered Dec 02 '15, 4:32 p.m.
Hi Cesar,

Is the issue only happening when exporting the work items to CSV? When you run the query in the WebUI for example, will it return all the 1000+ work items?

There is a CCM Advanced Property named "Maximum Query Result Set Size". However this property will not only affect exporting WI to CSV, it will also affect showing query results in WebUI or Eclipse.
Comments
Cesar Sasaki commented Dec 02 '15, 4:46 p.m.

 Hi Alexandre


Yes on this is only happening on exporting. When I run the query on the webUI or the eclipse client it returns +1000. (Like showing 1000 from 2000 records).

Any other thing that I need to notice?

Alexandre Stegani commented Dec 08 '15, 2:29 p.m.

I can´t think of any other settings that might be causing this issue. I´d like to suggest to narrow down the issue. Is this happening with all queries? All project areas? Does it happen if you create a new workspace from scratch? How many columns is the query returning? If many, perhaps you can try to select less columns to see if the issue persists.

Your answer

Register or to post 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.