Topic
8 replies Latest Post - ‏2013-04-04T05:33:08Z by MarcvanLint
MarcvanLint
MarcvanLint
57 Posts
ACCEPTED ANSWER

Pinned topic RPE query returns not all WI from RTC

‏2013-03-23T08:38:55Z |
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/workItemcontextId=_7asdaH787asdjAs/*/*
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
Updated on 2013-04-04T05:33:08Z at 2013-04-04T05:33:08Z by MarcvanLint
  • Dragos.Cojocari
    Dragos.Cojocari
    1604 Posts
    ACCEPTED ANSWER

    Re: RPE query returns not all WI from RTC

    ‏2013-03-26T16:25:58Z  in response to MarcvanLint
    Hey 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

    Regards,
    Dragos

    RPE Actual
    • MarcvanLint
      MarcvanLint
      57 Posts
      ACCEPTED ANSWER

      Re: RPE query returns not all WI from RTC

      ‏2013-04-03T08:16:14Z  in response to Dragos.Cojocari
      Sorry, 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:

      <stringExtensions>
      <helperId>_xTFUVFjcEeKBV_b7PczFYg</helperId>
      <key>customer</key>
      <value>Customer.literal.l127</value>
      <numericValue>0.0</numericValue>
      </stringExtensions>
      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.

      Thanks,
      Marc
      • MarcvanLint
        MarcvanLint
        57 Posts
        ACCEPTED ANSWER

        Re: RPE query returns not all WI from RTC

        ‏2013-04-03T15:38:09Z  in response to MarcvanLint
        Please see also:

        https://jazz.net/forum/questions/104578/is-there-a-way-to-filter-a-reportable-rest-url-by-the-value-of-a-custom-attribute
    • MarcvanLint
      MarcvanLint
      57 Posts
      ACCEPTED ANSWER

      Re: RPE query returns not all WI from RTC

      ‏2013-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 )
  • Dragos.Cojocari
    Dragos.Cojocari
    1604 Posts
    ACCEPTED ANSWER

    Re: RPE query returns not all WI from RTC

    ‏2013-04-03T18:28:49Z  in response to MarcvanLint
    Hey 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.
    Regards,
    Dragos
    RPE Actual
    • MarcvanLint
      MarcvanLint
      57 Posts
      ACCEPTED ANSWER

      Re: RPE query returns not all WI from RTC

      ‏2013-04-03T19:04:21Z  in response to Dragos.Cojocari
      Dragos (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?
  • Dragos.Cojocari
    Dragos.Cojocari
    1604 Posts
    ACCEPTED ANSWER

    Re: RPE query returns not all WI from RTC

    ‏2013-04-03T19:39:40Z  in response to MarcvanLint
    Hey 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

    Regards,
    Dragos

    RPE Actual