How can I create RTC 3.0 WorkItem Reports without RPE and RDDI
I am at a site that has RTC 3.0.5 and we do not have RDDI or RPE. I have been asked to produce Work Item queries and respective reports. Is there any way I can create a report (based on a query) that contains headers and or field tags along with the associated data? Can something be written in perl or another language that can query the Work Items and get selected field information using an API? |
6 answers
Please check the following WIKI. It may have what you are asking for:
https://jazz.net/wiki/bin/view/Main/ReportsCentral#Work_Item_Query |
I will definitely look into this approach, but I am still interested in REST API. Is REST API a viable approach and is there a perl interface into REST API Comments
Robert Wen
commented Oct 20 '14, 8:45 a.m.
It could be done using the REST API but you have to do all the heavy lifting.
You'd have to handle at least the following:
1. Setting up the OAuth handshake
2. Setting up the GET request
3. Formatting the output from the response
I know with Perl there are modules around that can handle the http requests, I don't know if they've been extended to handle REST.
Hope this helps
|
Hello Bob,
BIRT is an eclipse component and it's free to download. The first of the links I posted above, provides the necessary instructions to download and install it in your RTC client. Best Regards, Francesco Chiossi |
Thank you Robert and Francesco, We do not have BIRT either. Is there a free version of BIRT that can be downloaded for Windows 7. Also I was looking at REST API, is this a viable approach? I am not an XML programmer (but I can learn), but I also was wondering is there a perl interface into REST API? |
Hello Bob,
following up on the BIRT option mentioned by Robert, you can see some introductory articles here: Creating custom reports with BIRT and Rational Team Concert: Part 1. Basic reports http://www.ibm.com/developerworks/rational/library/10/creatingcustomreportswithbirtandrtc-part1/ Creating custom reports with BIRT and Rational Team Concert: Part 2. Complex reports and nested data sets http://www.ibm.com/developerworks/rational/library/10/creatingcustomreportswithbirtandrtc-part2/index.html Creating custom reports with BIRT and Rational Team Concert: Part 3. Advanced reporting techniques http://www.ibm.com/developerworks/rational/library/10/creatingcustomreportswithbirtandrtc-part3/index.html Best Regards, Francesco Chiossi |
A couple of alternatives spring to mind.
1. You can create a report resource that would be the basis of a report by downloading and installing BIRT onto your Eclipse client.
2. This may be applicable to later versions of RTC, but I think you can export the results of a query as a CSV file.
Hope this helps
|
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.