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

Get category of artefact in RQM with BIRT report

Questions
Tags
Users
Badges
Dmitry A. Lesin
(248●2●69●96) edited
Apr 22 '15, 7:40 a.m.
Hello!
Does anybody know how a list of unique categories names for Rational Quality Manager' project area could be queried in BIRT report. For example, a list of values as shown in next screenshot:



Thank you very much in advance!

1 vote

1 answer
6,137 views
1 vote

Accepted answer

Permanent link
Donald Nong
(14.5k●6●14) Apr 24 '15, 1:05 a.m.
Have a look at the table "com.ibm.rqm.planning.Category" in the LIVE_SNAPSHOT. You may find some information about the other odd bits in the other "com.ibm.rqm.planning.Category*" tables.
Dmitry A. Lesin selected this answer as the correct answer

1 vote

Comments
Dmitry A. Lesin
Apr 27 '15, 5:14 a.m.
Hi Donald, Thank you very much! I know about this table but I couldn't find values of categories. I Found columns with "category" prefix but they contain only different metadata. But the values themselves are placed into "name" column.

Dmitry A. Lesin
Apr 27 '15, 6:00 a.m.
But there's a problem with this table. I can not find all used values of categories here. So, I can make a conclusion that this way doesn't work!

Donald Nong
Apr 27 '15, 11:24 p.m.
Can you elaborate what does not work? The table "CategoryType" contains the "Categories" and "Sub Categories" as seen on the GUI, while the table "Category" contains "Values". After I add a category or value on the GUI, I can see it straightaway in the BIRT data set.

Dmitry A. Lesin
Apr 28 '15, 3:49 a.m.
Sorry! I believe the second issue is a different problem at all. I can not explain what the reason of that, but when I copy/pasted the same table from old report, I have got all needed values. Although it's strange because the tables (old and new) are equal at all! Anyway, your answer was full and clear! The mentioned table works perfect! Thank you very much!

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.

Ask a question
Guidelines
FAQ
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,144
× 324
× 232

Question asked: Apr 22 '15, 7:35 a.m.

Question was seen: 6,137 times

Last updated: Apr 28 '15, 3:49 a.m.

Confirmation Cancel Confirm