How to Sort RQM Category in RPE Template ?

sunil kumar

(17●2●2●7) Dec 30 '20, 2:00 a.m.

Hi,.

I have imported testcases into RQM, the created test case id are in random, while generating the report through rpe i m getting the random id in the report. I can able to sort the testcase according to the id and title. But in my case i want to sort according to the category field. I'm not able to do that.

I have created the category filed named "TC No." and given numbers in order. So i want to generate the report in the sequence of "TC No.". while i have searched in the internet i got an information that this can be done through Java scripting .

Any one can help me to resolve the issue by providing the javascript or any other solution to generate the test case in sequence order?

Thanks in Advance..

Regards,

Sunil

0 votes

2 answers

4,653 views

0 votes

Accepted answer

Permanent link

Subramanya Prasad Pilar

(4.6k●1●6) edited

Jan 03 '21, 8:59 a.m.

Yes, you cannot sort on category/value (which is child attribute). You can store the testcase data (that you want to print) in an array along with feed/entry/content/testcase/category/value in an array. Perform sort on the array and then print the elements from the array. A sample RPE template will look like this:

Use the following JavaScript Code within $6:

if (term == "TC No.") {

_tcNo = value;

}

if (term == "Module") {

_module += "," + value;

}

Use the following JavaScript Code outside $6: //Store testcase data in array

if ( _tcdata == ""){

_tcdata = [];

}

var obj = new Object();

obj[ "webId"] = webId;

obj[ "title"] = title;

obj[ "tcNo"] = _tcNo;

obj[ "module"] = _module;

_tcdata.push( obj);

//reset the category values

_tcNo = "";

_module = "";

You can then perform sorting. The sort() method will use the compare function to determine the orders of elements.

After this, you can use Iteration element to print the testcases (from the array) into the Cell.

if ( _tcdata != "")

{

var obj = _tcdata[_i1];

obj["webId"]; // similarly print obj[ "title"]; / obj[ "tcNo"]; / obj["module"].replace(/(^\s,)|(,\s*$)/g, ''); in other Cells

}

sunil kumar selected this answer as the correct answer

0 votes

Comments

sunil kumar

Jan 01 '21, 4:41 a.m.

Hi, Thanks for your Response. I have tried the steps but i got the blank report. In the Iteration script : while _i*1 < _tcdata.length; other than this we need to add anything on the iteration script. Regards, Sunil

Subramanya Prasad Pilar

Jan 01 '21, 5:27 a.m.

_i*1 < _tcdata.length is "Do while condition" for the Iteration element. Please check if the data is stored in the array first. You can refer the sample template here. You should use https://<server>:9443/qm/service/com.ibm.rqm.integration.service.IIntegrationService/resources/<projectAlias>testcase?abbreviate=false as URI for Testcase Feed data source.

sunil kumar

Jan 01 '21, 10:05 a.m.

Hi, Thank you subramanya it's really worked for me. Thanks a lot . I do have one more query i m having another category named modules with values M1,M2 i need to print these module content to the generating content of the test case. like TC.no Module Title TCB1001 M1 Login page TCB1002 M2 Home Page TCB1003 M1 Payment page Is there any way to generate like the above one.

One other answer

Permanent link

sunil kumar

(17●2●2●7) Jan 03 '21, 2:42 a.m.

Hi,

I have tried the script that you have shared, It was creating duplicate testcases in the report as shown below..

Here 1st Column is Test case Id.

9	Payment page		M2
6	Login Page
6	Login Page		M1
9	Payment page
8	Profile Page
7	Home page		M1
8	Profile Page		M2
7	Home page
7	Home page	TCB10001
6	Login Page	TCB10002
8	Profile Page	TCB10003
9	Payment page	TCB10004

0 votes

Comments

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.

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

usage

× 12,144

rational-quality-manager

× 11,039

clm

× 7,622

elm

× 1,452

test-management

× 893

Question asked: Dec 30 '20, 2:00 a.m.

Question was seen: 4,653 times

Last updated: Jan 06 '21, 8:25 a.m.

How to Sort RQM Category in RPE Template ?

2 answers

4,653 views

0 votes

Accepted answer

Comments

One other answer

Comments

Your answer

Follow this question

Question details

Related questions