It's all about the answers!

Ask a question

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?


Raj Kapoor (2741930) | asked May 05 '21, 1:52 a.m.


Is it possible to make it just Manual?

Accepted answer


permanent link
Fariz Saracevic (904613) | answered May 05 '21, 3:14 a.m.
FORUM MODERATOR / JAZZ DEVELOPER

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

Comments
Raj Kapoor commented 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 commented May 05 '21, 3:55 a.m.
FORUM MODERATOR / JAZZ DEVELOPER

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 commented 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 commented 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 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.