It's all about the answers!

Ask a question

RTC Eclipse client query results limitted to 1,000 rows - how to retrieve rows after 1,000?


1
1
Michael Taylor (7854560) | 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?

2 answers



permanent link
Takehiko Amano (1.3k2941) | answered Sep 09 '13, 10:22 p.m.
JAZZ DEVELOPER
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.


Advanced Property of RTC

Comments
Michael Taylor commented Sep 10 '13, 1:30 p.m.

Thank you.  How do we access and change the Max Query Result Set Size (through RTC Web UI, Eclipse UI, which screen, etc.)?

How would we run the query com.ibm.team.workitem.service.internal.query.QueryRepositoryService?


Ralph Schoon commented Sep 10 '13, 2:57 p.m. | edited Sep 10 '13, 2:58 p.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER

Web UI, CCM Admin, Advanced Properties in the Web UI: https://[server]:[port]/ccm/admin#action=com.ibm.team.repository.admin.configureAdvanced

Not sure about what the second question is asking for.


permanent link
Ralph Schoon (47.1k13440) | 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?

Your answer


Register or to post your answer.