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

Querying RRC Database

 Dear all,

Want to Query RRC Database and extract the list of RRC ID, Artifacts type, created date, created by, modified date, modified by to have a total inventory of RRC created for control purposes

With query i shall use various fillters and take the list that suits my consumption from time to time

How to do it..? There is no adhoc reporting in RRC and there is export available at each screen, but it is too time consuming and not getting me anywhere on keeping tab on daily basis

Any help would be appreciated

Advance thanks for your help

0 votes



3 answers

Permanent link
I don't think any existing features will meet your requirement. I believe you need to build your own tools using available APIs such as the reportable REST API.
https://jazz.net/wiki/bin/view/Main/RRCReportableRestAPI

0 votes

Comments

Yes, the reportable REST API would be a good choice.
Another option, though it would mean programming to extract what you want is the OSLC REST API: OSLC Rest API Workshop


Permanent link
I am not 100% I understand what you are looking for, but if you just want a daily delta of new artifacts would filtering on any artifacts created after your last day's export suit your needs? This can be done with a filter looking through your whole database and you can export this.

0 votes


Permanent link
Hello Vivekanandan,

if you have a configured data warehouse you can also get most of those information querying it.

You can see the details of the relations between RRC elements and Data Warehouse tables here:

Data dictionary for requirement artifacts
http://www-01.ibm.com/support/knowledgecenter/SSYMRC_5.0.2/com.ibm.rational.rrm.help.doc/topics/rm/rm-roles.html

check Data Warehouse Schema, Data Warehouse Table, Data Warehouse Column.

Best Regards,

Francesco Chiossi

0 votes

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
× 12,014

Question asked: Jan 22 '15, 11:13 p.m.

Question was seen: 3,631 times

Last updated: Jan 29 '15, 4:44 a.m.

Confirmation Cancel Confirm