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:
Based on the RTC Tutirial V3.pdf.
How to deal with this limitation/next in RPE? How to iterate with such a query?
Also available on https://jazz.net/forum/questions/107080/rpe-query-returns-not-all-wi-from-rtc
This topic has been locked.
8 replies Latest Post - 2013-04-04T05:33:08Z by MarcvanLint
Pinned topic RPE query returns not all WI from RTC
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2013-04-04T05:33:08Z at 2013-04-04T05:33:08Z by MarcvanLint
Re: RPE query returns not all WI from RTC2013-03-26T16:25:58Z in response to MarcvanLintHey Marc,
RPE 1.1.2 and newer versions will pull all pages of data automatically. What RPE version are you using and how does your template look like? Since it seems you have trouble getting up to speed with RPE and RTC you should contact support.
You should also check this RPE 1.1.2 and RTC 3.0.1
Re: RPE query returns not all WI from RTC2013-04-03T08:16:14Z in response to Dragos.CojocariSorry, I formulated my question badly.
A workitem has a custom property "customer". I want to create reports based on tasks done for customers in a certain periode. Now I want to iterate across the customers and for every iteration. So I define a dynamic query as a first try:
https://csnext.ibm.com/ccm7/rpt/repository/workitem?fields=workitem/workItem contextId=_h1ryUHRHEeGZ06KwudyaEQ / *
(Hopefully the formatting does not garble my query now...)
This works fine! Except I get all Workitems from our project for every customer I ask. So I want to make a tighter query utilizing the customer field:
How should I formulate the additional constraint in the query above. I tried:
....contextId=_h1ryUHRHEeGZ06KwudyaEQ and stringExtensions/valuehttp://customer]=Customer.literal.l92/*
But that results in the message that it gives back multiple options. Any idea's or examples how to query a custom property (like my customer)?
I added my current template as an attachment.
Re: RPE query returns not all WI from RTC2013-04-03T18:30:12Z in response to Dragos.Cojocari"RPE 1.1.2 and newer versions will pull all pages of data automatically." -> When I run my report, using rather complex dynamic queries, it returns a subset of workitems (I think the first 100). When I add "&size=200000" than I get far more hits and is my report complete. That concludes to me that RPE will not pull all pages.
An other try of my query:
https://csnext.ibm.com/ccm7/rpt/repository/workitem?fields=workitem/workItemhttp://contextId=_h1ryUHRHEeGZ06KwudyaEQ and type/id=com.ibm.team.workitem.workItemType.businessneed\/\(id\|summary\|state/name\|stringExtensions/value\|type/id\|target/name\)&size=20000
(Remove Backslashes \, they are inserted to prevention of corrupting the formatting done by this forum editor )
Re: RPE query returns not all WI from RTC2013-04-03T18:28:49Z in response to MarcvanLintHey Marc,
if the answer you get from the server is the same as mentioned here it means that the filter is syntactically right but it cannot be performed by RTC due to the type of the property stringExtensions/value.
Re: RPE query returns not all WI from RTC2013-04-03T19:04:21Z in response to Dragos.CojocariDragos (and others) - I understand I hit a RTC problem. Remains the other item that I have to add the size variable in a query. See previous append of me. How is that called in RTC-terms? A feature?
Re: RPE query returns not all WI from RTC2013-04-03T19:39:40Z in response to MarcvanLintHey Marc,
I am able to successfully pull paged data from RTC. If you run into issues on your side with RPE not pulling all the data than please contact support. In that way you can also raise the RTC related issue