It's all about the answers!

Ask a question

RPE query returns not all WI from RTC


Marc van Lint (852127) | asked Mar 23 '13, 4:28 a.m.
JAZZ DEVELOPER
I try to create reports with RPE from RTC (CSNEXT - IBM Internal system). The approach I follow is to get the contextID of my project and use that in a dynamic datasource to get specific WIs. This only returns a subset (probably 100) first workitems.
I know there is a delibarate limit in RTC to give only a few and a next option.

The dynamic query used results in something like:
https://csnext.ibm.com/ccm7/rpt/repository/workitem?fields=workitem/workItem[contextId=_7asdaH787asdjAs]/*/*
Based on the RTC Tutirial V3.pdf.

How to deal with this limitation/next in RPE? How to iterate with such a query?

3 answers



permanent link
Erwin Kunz (94686283) | answered Mar 25 '13, 12:14 p.m.
use &size=400 at the end of your URL

Comments
Marc van Lint commented Mar 25 '13, 12:22 p.m.
JAZZ DEVELOPER

Hi Erwin, thanks for helping.
It's an alternative - certainly. Currently I use 100000. Just to be sure...
But are there any options to loop with RPE. Something like:

do query give next 100
   process the selection)
   if (number > 10000) stop loop
end

Any idea?


permanent link
Erwin Kunz (94686283) | answered Mar 26 '13, 3:21 a.m.
Hi Marc

Not sure what you are trying. Loops are automatically done by RPE

1st I create a variable with my URL
2nd create a Data Source Configuration and use the variable as input
3. Create a container, containing a table containing a Row containing cells

run ... and it loops trough


permanent link
Erwin Kunz (94686283) | answered Mar 26 '13, 3:21 a.m.
Hi Marc

Not sure what you are trying. Loops are automatically done by RPE

1st I create a variable with my URL
2nd create a Data Source Configuration and use the variable as input
3. Create a container, containing a table containing a Row containing cells

run ... and it loops trough

Your answer


Register or to post your answer.