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

Bob Ferguson

(89●15●44) 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?

0 votes

6 answers

7,041 views

0 votes

6 answers

Permanent link

Robert Wen

(690●4●12) 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

1 vote

Permanent link

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

1 vote

Permanent link

Bob Ferguson

(89●15●44) 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?

0 votes

Permanent link

Francesco Chiossi

(5.7k●1●11●19) 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

0 votes

Permanent link

Bob Ferguson

(89●15●44) 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

0 votes

Comments

Robert Wen

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

Rafik Jaouani

JAZZ DEVELOPER (5.0k●1●6) Oct 23 '14, 2:19 p.m.

Please check the following WIKI. It may have what you are asking for:
https://jazz.net/wiki/bin/view/Main/ReportsCentral#Work_Item_Query

0 votes

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.

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

rational-team-concert

× 43,043

reporting

× 484

Question asked: Oct 17 '14, 4:08 p.m.

Question was seen: 7,041 times

Last updated: Oct 23 '14, 2:19 p.m.

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

6 answers

7,041 views

0 votes

6 answers

Comments

Your answer

Follow this question

Question details

Related questions