It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Follow this question
Question details

×42,788
×10,828

question asked: Oct 17 '11, 4:03 a.m.
question was seen: 5,289 times
last updated: Oct 17 '11, 4:03 a.m.

Related questions

FAQ - How this Forum works

Query more than 1000 work items page by page

0
Chao Yang Guo (6●5●3) | asked Oct 17 '11, 4:03 a.m.
JAZZ DEVELOPER
Hi,
Customer need to retrieve all work items (more than 5 M items) in RTC to analysis in their BI system, like our Data warehouse.

But as we know, we limit the query item number to 1000 by default.

If we change this limit in "Advanced properties" page by changing "Maximum Query Result Set Size" number and restart server, what is the max size we should set and what is the performance impact to server?

If we set the max size to 5M (like 5,000,000), does it mean it will load 5M items into memory even I use the client side OSLC paging service (each page have 100 items)? Thanks!

Steven

One answer

Most liked answers ↑|Newest answers|Oldest answers

0
permanent link
Ralph Schoon (63.1k●3●36●46) | answered Jan 13 '12, 8:22 a.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER
I would suggest to use the plain Java API to write a tool that gets all work items out. There you can change the limit. 


		IQueryResult<IResolvedResult<IWorkItem>> resolvedResults = queryClient.getResolvedQueryResults(queryToRun, IWorkItem.FULL_PROFILE);

		resolvedResults.setLimit(Integer.MAX_VALUE-1); // First thing to do!!!!!!


Otherwise the limit is for all users. If the limit is set to 5M in the advanced properties a user could query 5M work items. He would load them paginated still.

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.