Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

RTC Reporting Capability: Is there a way to generate a list of all projects?

My organization periodically needs to be able to collect a list of all projects currently in active development - together with a few custom pieces of information (project names, team leader names, usage, etc.).  Does anyone know whether RTC has reporting features which could be used to generate something like this?  If not, is the RTC database schema published somewhere so I could put together an application to query and create custom reports like this?

0 votes

Comments

Note that for specific guidance, you would need to identify how you map your "projects" into RTC artifacts.   One common approach (if a different team is working on each project) is to use a separate team area for each project.   Another approach is to have a separate stream for each project.



2 answers

Permanent link
Hi, David

You may be able to customize reports using RRDI/Insight to get the expected results but you may want to check with a simpler way using Reportable API first and see if that meet your needs.
For example, a project name list:

https://server:port/ccm/rpt/repository/foundation?fields=projectArea/projectArea/name

More details on REST API: https://jazz.net/wiki/bin/view/Main/ReportsRESTAPI#foundation

thanks

1 vote


Permanent link
Hi David,
You can also easily do it using Report Builder. You can use a custom query there on Data Warehouse.

1 vote

Your answer

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

Search context
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

Question asked: May 05 '16, 2:27 p.m.

Question was seen: 1,528 times

Last updated: Jun 05 '16, 6:56 p.m.

Confirmation Cancel Confirm