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
Remove the limit on OSLC 1.0 query results and ignore the “Maximum Query Result Set Size” limit for calls from QP (336705)
3 other answers
Comments
hello Eric,
Thank you for the response.
We are already doing paging to get results in chunks of 50's until 1000. But the problem if we there are more than 1000 workitems resulting from the query, the response received is listing only for 1000 workitems. Actual count of workitems is not returned.
Regards,
Radha
OK,
https://jazz_instance/ccm/oslc/contexts/project_uuid/workitems?oslc_cm.pageSize=50&oslc_cm.query='my_query'
Comments
Radha Nagaraja
Jul 10 '14, 12:43 a.m.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?
Rohit Balduwa
Jul 10 '14, 12:50 a.m.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.
Radha Nagaraja
Jul 10 '14, 1:02 a.m.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
Vivek Pandey
Feb 18 '15, 8:31 p.m.Hi Radha,
Radha Nagaraja
Feb 18 '15, 3:09 a.m.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.