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

BIRT report and TestSuite sections

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

0 votes


Accepted answer

Permanent link
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

1 vote

Comments

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

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


3 other answers

Permanent link

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:

0 votes

Comments

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.

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


Permanent link

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

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

0 votes

Comments

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,

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

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
× 481
× 324
× 230

Question asked: May 13 '13, 11:03 a.m.

Question was seen: 7,148 times

Last updated: May 16 '13, 4:14 a.m.

Confirmation Cancel Confirm