Unable to query more than 1K workitems using REST
Querying Wrokitems in RTC using REST APIs:
With OSLC v2.0
when we get the query list using REST, only the URI with Query ID’s is listed and not the complete details of the query. But when we try to get the details of the query with the result query URI returned, it throws 406 Not Acceptable response. With OSLC v1.0When we try to get the query result total count, it returns only 1000 even if it has more workitems. Also it doesn’t return the next page URL to traverse through the next list. Any hints how to proceed here will be of great help. |
Accepted answer
Geoffrey Clemm (30.1k●3●30●35)
| answered Feb 18 '15, 8:30 p.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER
This limitation is being removed in 6.0. See the following work item for details:
Remove the limit on OSLC 1.0 query results and ignore the “Maximum Query Result Set Size” limit for calls from QP (336705) Radha Nagaraja selected this answer as the correct answer
|
3 other answers
Hello Radha,
possibly use pagination:
https://jazz.net/wiki/bin/view/Main/WorkItemAPIsForOSLCCM20#Pagination
Hope it helps,
Eric
Comments
Radha Nagaraja
commented Jul 10 '14, 4:18 a.m.
hello Eric,
OK,
It might help you overcome your issue, and contains links to OSLC spec
Eric
|
|
Just wondering if this enhancement will also include results obtained by using oslc_cm.query e.g. at the moment I am getting paginated results and using the 'next' link, but once the startAt property gets to 1000 it stops no matter what my pageSize is.
https://jazz_instance/ccm/oslc/contexts/project_uuid/workitems?oslc_cm.pageSize=50&oslc_cm.query='my_query' |
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.
Comments
I've already seen that the display query limit option on RTC admin page which can be changed from 1000 to any other number.
But I do not know it is has any impact on REST querying. Even if so, is there an adverse effect of changing the count to a bigger number in RTC?
Hi
Go to the below location:
https://<<hostname:port>>/ccm/admin#action=com.ibm.team.repository.admin.configureAdvanced
Search for 'Maximum Query Result Set Size', you can edit the value from default1000 to 1500 or 2000.
Yes, there will be impact on the performance if you set high range of query result set.
I am not sure of the impact on REST querying.
Hello Rohit,
Thanks for the info on performance.
Like I mentioned, even if the maximum limit is changed to a bigger number, there is no way to recursively get all workitems beyond the defined RTC limit.
Hence changing it to a bigger number is like pushing the problem to a later time and not a solution for us unfortunately :(
Regards,
Radha
Hi Radha,
hello Vivek,
We have not solution for REST. What we intend to do is to automate csv export feature of RTC for queries and use the output for processing further.