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

JRS- Report Builder display "com.ibm.rqm.planning.common.scripttype.manual" value under table column type. How I can change displayed value to to just Manual?

Questions
Tags
Users
Badges
Raj Kapoor
(27●4●20●31) May 05 '21, 1:52 a.m.


Is it possible to make it just Manual?

0 votes

1 answer
903 views
0 votes

Accepted answer

Permanent link
Fariz Saracevic
FORUM MODERATOR / JAZZ DEVELOPER (919●6●13) May 05 '21, 3:14 a.m.

Hi Raj,


Please open support ticket to investigate this issue.

In the meantime, you could create a custom expression to change value, for example IF($QM Test Script:Script Type$ = 'com.ibm.rqm.planning.common.scripttype.manual','Manual',0). 

Raj Kapoor selected this answer as the correct answer

1 vote

Comments
Raj Kapoor
May 05 '21, 3:40 a.m.

Thanks Fariz for such a quick response, and guiding me. I tried the solution but received an error "The expression contains an unknown attribute: '$QM TestScript:Script Type$'"


Thanks again! now I at least know the approach.

Pranav 

Fariz Saracevic
FORUM MODERATOR / JAZZ DEVELOPER May 05 '21, 3:55 a.m.

Hi Raj,


Example is based on my data model. You need to find the right attribute for Test Script Type and replace it with '$QM TestScript:Script Type$'.

Raj Kapoor
May 05 '21, 7:49 a.m.

Hello Fariz,


Sorry for bothering gain.
I tried IF($Testscript:Type$ = 'com.ibm.rqm.planning.common.scripttype.manual','Manual',0) but it throws CRRGW5628E An com.microsoft.sqlserver.jdbc.SQLServerException error occurred when validating the input SQL string, caused by A processing error "Incorrect syntax near the keyword 'IF'." occurred..

Any documentation available for custom expression for me to refer.

Thanks
Pranav


Raj Kapoor
May 05 '21, 8:31 a.m.

Hello Fariz,


Thanks a lot for guiding me.
Below expression worked-
CASE 
WHEN ($Testscript:Type$ = 'com.ibm.rqm.planning.common.scripttype.manual') THEN 5


Thanks

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.

Ask a question
Guidelines
FAQ
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
× 7,497
× 1,327
× 360
× 112
× 13

Question asked: May 05 '21, 1:52 a.m.

Question was seen: 903 times

Last updated: May 05 '21, 8:31 a.m.

Confirmation Cancel Confirm