It's all about the answers!

Ask a question

How can I create RTC 3.0 WorkItem Reports without RPE and RDDI


Bob Ferguson (891544) | asked Oct 17 '14, 4:08 p.m.

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



permanent link
Rafik Jaouani (5.0k16) | answered Oct 23 '14, 2:19 p.m.
JAZZ DEVELOPER
Please check the following WIKI. It may have what you are asking for:
https://jazz.net/wiki/bin/view/Main/ReportsCentral#Work_Item_Query

permanent link
Bob Ferguson (891544) | answered Oct 20 '14, 8:01 a.m.

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


permanent link
Francesco Chiossi (5.7k11119) | answered Oct 20 '14, 6:59 a.m.
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

permanent link
Bob Ferguson (891544) | answered Oct 20 '14, 6:49 a.m.

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?


permanent link
Francesco Chiossi (5.7k11119) | answered Oct 20 '14, 2:53 a.m.
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

permanent link
Robert Wen (690412) | answered Oct 17 '14, 4:15 p.m.
 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


Register or 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.