It's all about the answers!

Ask a question

BIRT report and TestSuite sections


Mathieu Defianas (15942838) | asked May 13 '13, 11:03 a.m.
Hello,

I use RQM version 4.0.1 and I would like to put, in a BIRT report, TestSuites sections, for example Pre-conditions.
I have created a Datasource on http://server/qm with "LIVE_SNAPSHOT".
Then, I have searched to understand how to get TestSuite sections in a DataSet.
First, I have used the com.ibm.rqm.planning.TestSuite table and the column section.***.
Nevertheless, I only see names and ID but not values ...
I can see sections that interests me but I do not find the value :
  • id = com.ibm.rqm.planning.editor.section.testSuitePreCondition
  • name = RQM-KEY-TSUITE-PRE-COND-TITLE
Then I have searched in the com.ibm.rqm.template.StaticSection and com.ibm.rqm.template.DynamicSection tables but I have not found any value as well.

Can you help me, please ???
Thanks
Mathieu

Accepted answer


permanent link
Jun Wang (6077) | answered May 14 '13, 2:27 a.m.
Exactly, I checked the code of LIVE_SNAPSHOT to try to understand how it get the model and its fields. I found that only the queryable fields in the model will be added into the live snapshot table.

NOTE
: the code of LIVE_SNAPSHOT is maintained in Jazz foundation reporting team and RQM reporting team can not do anything against it.

However, the value of section is stored in 'content' filed of com.ibm.rqm.planning.common.ISection model, and the type is 'Content' where it is able to store the rich text, but it is not added queryable attribute. So you can not see it in the table of LIVE_SNAPSHOT.

You can consider to use RPE or RRDG to export the fields instead of BIRT report. I remember the value of section is exposed by RQM reportable REST API, please refer to https://jazz.net/wiki/bin/view/Main/RqmApi.

Could the inner PDF exporting ability of RQM meet your requirement?
Mathieu Defianas selected this answer as the correct answer

Comments
Mathieu Defianas commented May 14 '13, 5:59 a.m.

Hello Jun,

Thanks for your response.
I am going to switch to RPE in order to export this sections.
The PDF export is impossible in my case, because in some fields, with lots of tables or images, the export failed. In fact, the objects overlap ...

I have just a last question : the default PDF export is linked with predifined RPE report or other technology ?

Thanks
Mathieu


Jun Wang commented May 14 '13, 8:06 a.m.

No, the default PDF export is not using RPE and it is developed by RQM itself.

3 other answers



permanent link
Mathieu Defianas (15942838) | answered May 14 '13, 8:23 a.m.
edited May 14 '13, 8:24 a.m.
Jun,

I have connected RPE Studio with a schema REST using the url https://myRQMserver/qm/rpt/repository?metadata=schema.
I have used the "generic" href name and I have tried to found the com.ibm.rqm.planning.common.ISection model without success ...
Where is stored this model ?
Thanks for your help

Mathieu

permanent link
Jun Wang (6077) | answered May 14 '13, 8:32 a.m.

Your URL format is incorrect for RQM, please refer to:

https://jazz.net/wiki/bin/view/Main/RqmApi#RQM_Schema


Comments
Mathieu Defianas commented May 14 '13, 10:54 a.m.

Sorry Jun but the documentation is not really clear.
As described in the wiki, I have used the url https://myRTCserver/qm/service/com.ibm.rqm.integration.service.IIntegrationService/schema/?????.xsd.
I have replaced ????? by some schemas for example feed.xsd  or qm.xsd but I don't find com.ibm.rqm.planning.common.ISection in all schemas
Can you help me ?
Mathieu


permanent link
Jun Wang (6077) | answered May 14 '13, 11:44 p.m.

No, the name com.ibm.rqm.planning.common.ISection is interface name in code and not the name in REST API. Sorry for the confusing.

Please try the URL:


Comments
Jun Wang commented May 14 '13, 11:51 p.m.

Why is my wrote content changed after posting?

Please try the URL:

https://<RQMServer>:<port>/qm/secure/service/com.ibm.rqm.integration.service.IIntegrationService/schema/qm.xsd

Under the top resource 'testsuite', you will find 'com.ibm.rqm.planning.editor.section.testSuitePreCondition' that is what you wanted.


Mathieu Defianas commented May 16 '13, 4:14 a.m.

Jun,
Finally with your url we haven't succeeded to obtain results ;-( I don't understand but the fields are unavailable : they are disabled.
But, we have tried to use the url https://qmserver:port/qm/service/com.ibm.rqm.integration.service.IIntegrationService/resources/qm project area/testsuite and this case, I have the field and I have succeeded to obtain TestSuite sections.
Regards
Mathieu

Your answer


Register or to post your answer.