RPE query returns not all WI from RTC

Marc van Lint (85●21●28) | 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

Most liked answers ↑|Newest answers|Oldest answers

permanent link

Erwin Kunz (946●8●64●86) | 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 (946●8●64●86) | 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 (946●8●64●86) | answered Mar 26 '13, 3:21 a.m.

It's all about the answers!

Related questions

RPE query returns not all WI from RTC

3 answers

Your answer