RPE query returns not all WI from RTC

Marc van Lint (85●21●29) | 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●70●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●70●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●70●86) | answered Mar 26 '13, 3:21 a.m.

Your answer

Register or log in to post 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.

It's all about the answers!

Related questions

RPE query returns not all WI from RTC

3 answers

Your answer