Quality Manager DB Tables and BIRT
One answer
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.
Comments
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 ?
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.
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.
Comments
Guilherme Silva
Sep 03 '13, 7:32 a.m.Hi Rafael,
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.