Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

RPE query returns not all WI from RTC

Questions
Tags
Users
Badges
Marc van Lint
JAZZ DEVELOPER (85●21●29) Mar 23 '13, 4:28 a.m.
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?

0 votes

3 answers
6,469 views
0 votes

3 answers

Permanent link
Erwin Kunz
(946●8●70●86) Mar 25 '13, 12:14 p.m.
use &size=400 at the end of your URL

0 votes

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

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) 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

0 votes

Permanent link
Erwin Kunz
(946●8●70●86) 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

0 votes

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.

Ask a question
Guidelines
FAQ
Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 12,019

Question asked: Mar 23 '13, 4:28 a.m.

Question was seen: 6,469 times

Last updated: Mar 26 '13, 3:21 a.m.

Confirmation Cancel Confirm