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

Quality Manager DB Tables and BIRT

Questions
Tags
Users
Badges
Rafael Rodriguez Montes
(230●14●130●258) Jun 03 '13, 4:58 p.m.
 Hi, 
Im working with custom queries because I need to create custom reports using BIRT, but is dificult work with the tables of database of QM, I waste time looking how works the cubes, Exist documentation about the database of Quality Manager ? and how create a custom queries for BIRT ( Create advance Data set),

Thank you I appreciate your help. 

0 votes

Comments
Guilherme Silva
Sep 03 '13, 7:32 a.m.
Hi Rafael, How did you manage to create custom queries in RQM? I need a simple query/view that includes custom fields. Do you have any references on how to do that?

Rafael Rodriguez Montes
Sep 03 '13, 10:51 a.m.
Hi Guilherme, I had to use RDDI 2.0.1 because if you want to use BIRT, may you could spend several time, so my recommendation is to install RDDI in the same server or other, and perform the integration with QM, and you able to include the costume field values and metadata. is easier to do. 

1 answer
8,555 views
0 votes

One answer

Permanent link
Jun Wang
(607●7) Jun 03 '13, 11:41 p.m.
Hi, we do not suggest customization of BIRT reports, please considering RRDI or Rational Insight to customize reports.
As your said, the tables that you can see in BIRT data sets are hard to understand for the non-developers, and you can not add new fields missing into the available virtual snapshot tables that requires to modify our source code. In general, we do not suggest user do it and RRDI reporting is for customization.

0 votes

Comments
Rafael Rodriguez Montes
Jun 04 '13, 3:40 p.m.
even for developers, for example, Im trying to get the list of test results in real time, I'm using LIVE_EXEC_RESULT table, and I need to get the date of execution, but I see integer values in this attributes, so how can I interpret ? exit others tables with fields in date format bur in this case no, so how can I get in real time ?

Jun Wang
Jun 05 '13, 5:04 a.m.
Sorry, I just checked that it is a defect of our code. :-) We defined the type of the two fields to Long type instead of Timestamp. I also tried to use "new Date(The long time)" to translate the long value to the date time type in BIRT template, but it is still incorrect. I will create a defect against it later. The start time and end time of a TCER's current result is correct in LIVE_EWI table, if you just need to report TCER's current result not all results, you could use this table. If you would like to report start time and end time of all test case results, please create a PMR or escalation for us, then I could provide a test fix for you.

Jun Wang
Jun 05 '13, 5:15 a.m.
I created a defect Start time and end time of execution result in some live tables of BIRT service layer can not be reported (88516) to track it and try to resolve it in RQM 4.0.4.

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
× 7,622
× 6,180
× 1,736
× 383

Question asked: Jun 03 '13, 4:58 p.m.

Question was seen: 8,555 times

Last updated: Sep 03 '13, 10:51 a.m.

Confirmation Cancel Confirm