Regarding the maximum limit on the query results in RTC
Hi,
I am using BIRT to get all the children associated with an initiative recursively.
for this I am trying to get all the rows from the links table with LINK_TYPE as 'com.ibm.team.workitem.linktype.parentworkitem'
and then traverse the dataset using javascript to get the .parent child tree.
The problem is the query results from LINKS table is limited to 1000.
i followed
https://jazz.net/forum/questions/126270/rtc-eclipse-client-query-results-limitted-to-1000-rows-how-to-retrieve-rows-after-1000
and changed "Maximum Query result set size" to 10000.
but still i am getting the number of rows in dataset as 1000.
even i tried by restarting the server also, but still it is showing 1000.
can you please provide any suggestions ?
regards,
Nagaraju.V
Accepted answer
Hi Nagaraju,
There is a limit of 10000 work items in report preview in BIRT. See this thread: https://jazz.net/forum/questions/105234/why-birt-report-across-multiple-rtc-projects-do-not-list-all-wis-which-would-have-otherwise-listed-project-by-project.
that should help.
There is a limit of 10000 work items in report preview in BIRT. See this thread: https://jazz.net/forum/questions/105234/why-birt-report-across-multiple-rtc-projects-do-not-list-all-wis-which-would-have-otherwise-listed-project-by-project.
that should help.
2 other answers
Hi Nagaraju,
I tried to change the Max Query Result Set Size and it is able to pick up the changes. I do not have 10000 to test if it works on such large number of results but I tried 3 and 100 and both works for me. Do you mind trying 1500 resutls. for that go to Web UI, CCM Admin, Advanced Properties in the Web UI: https://[server]:[port]/ccm/admin#action=com.ibm.team.repository.admin.configureAdvanced and set the value to 1500 and see if that gets picked up. Also, 10000 is a very large number and it might cause JTS performance issue. Once you make the changes you do not need to restart the server. It will pick up the changes automatically. let me know if the above test works. Thank you
In the thread:
https://jazz.net/forum/questions/105234/why-birt-report-across-multiple-rtc-projects-do-not-list-all-wis-which-would-have-otherwise-listed-project-by-project
the limit is one thousand, but your answer is ten thousands, is it spelling error?
Which is the correct number?