Access Custom RQM Testplan Section in JRS
Hello,
our situation is:
We used a custom attribute in RQM with size medium text to capture some data we need for our quality process and used JRS to report on it.
Unfortunately, the size of the information we needed to store exceeded the amount that fits into a medium text attribute.
We now did create a custom section in the TestPlan template (rich text) in which our data fits but it seems this is not accessible in JRS (neither DWH nor LQE).
Is there any option we have to solve our issue?
Solution of cause could be as well to increasing the amount of data that can be stored in an medium text attribute.
I already found these questions related to RPE:
https://jazz.net/forum/questions/89659/print-custom-section-in-rqm-using-rpe
https://jazz.net/forum/questions/124705/how-to-query-custom-rqm-test-suite-section-with-rpe
Edit 2017-09-25:
We tried to access our custom Rich text Section via LQE (using JRS Report Builder). Can anyone please comment if this should work w.r.t the design? I can see all the system defined Rich text Sections if they are used in a Test Plan, but not our Custom one.
2 answers
Hi Thomas,
The two links you referred to are about the qm.xsd data source schema used in RPE, which explain the workaround of defect as below
http://www-01.ibm.com/support/docview.wss?uid=swg1PI65792
The problem in JRS is where to accommodate the custom attribute ( rich text ) in data warehouse. The following is the list of data stored in data warehouse.
https://www.ibm.com/support/knowledgecenter/SSYMRC_6.0.4/com.ibm.rational.test.qm.doc/topics/qm/Test-Plan.html
Medium text attributes are stored in table RICALM.TESTPLAN_STRING_M_EXT, but I am not sure which table for rich text attribute (RICALM.TESTPLAN_STRING_EXT ?). Can you find any data by SQL query (advanced section) as below?
select * from RICALM.TESTPLAN_STRING_EXT
or try using other tables listed in the link as above.
Comments
Hi Kenji,
Quality objectives can be linked with Testplans and also reportable.
https://www.ibm.com/support/knowledgecenter/SSYMRC_6.0.4/com.ibm.rational.test.qm.doc/topics/t_quality_obj_scenario.html
If you find where the custom attribute ( rich text ) is stored in data warehouse, please update here.
Hi Kenji,
my status: These informations besides the Quality Objectives cannot be accessed via Datawarehouse. The solution at the moment is only possible in LQE:
Build a Report based on LQE as source -> Select QM Testplan as artefact -> In the Traceability option, you can now select a Link to "Rich Text Section". The Rich Text Section Object has a Title, a Description, Content... The Title is the name of the Section, The Description is the description from the section definition and the Content is the actual rich text field. You can define conditions for the attributes of the Rich text Sections and show them in the result table.
I am still in the process of testing with my specific custom section, but currently it seems this is the only option...
1 vote