RTC Eclipse client query results limitted to 1,000 rows - how to retrieve rows after 1,000?
Michael Taylor (78●5●45●60) | asked Sep 09 '13, 9:38 p.m.
In the RTC Eclipse client when query results are over 1,000 rows, the first 1,000 rows are displayed. The counts at the bottom of the window are also correct (Showing 1,000 of 3,254). Scrolling to the bottom does not seem to cause the query to page. How can the remaining rows be viewed or retrieved?
Takehiko Amano (1.3k●29●41) | answered Sep 09 '13, 10:22 p.m.
Maximum Query result set size is set to 1000 by default. You may increase this number. However, there might be performance issues when the value is increased too much. Please carefully monitor database activity.
Ralph Schoon (46.7k●1●34●40) | answered Sep 10 '13, 2:01 a.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER
If you want to manipulate so many work items, you might want to think about automation. For examples, see: http://rsjazz.wordpress.com/2012/11/19/using-expressions-for-automation/ and http://rsjazz.wordpress.com/2012/10/29/using-work-item-queris-for-automation/
Please be aware that the limit mentioned above is a server limit. It is there for a reason: inexperienced users creating work item queries could put a lot of load on the system if they test and return huge amounts of data. The limit prevents that. And on the other hand, who would browse or scroll through more than 1000 items?