Question

2
Replies
613
Views
Vivek Sasidharam (VivekSasidharan_13)
Aegis Insurance

Aegis Insurance
IN
VivekSasidharan_13 Member since 2016 2 posts
Aegis Insurance
Posted: December 22, 2016
Last activity: January 9, 2017
Posted: 22 Dec 2016 5:15 EST
Last activity: 9 Jan 2017 15:26 EST
Closed

Dropdown unable to use SQL function field from Report Definition

I have sourced a Dropdown using a RD.  In the RD, one of the fileds uses the concatenate function. When the RD is run standalone it runs fine and returns the expected data.


If I try to use the concatenated RD property in the Dropdown, Pega throws errors and is NOT allowing to configure the concatenated property on the dropdown.


Below is the RD output.



In the dropdown control in the section, the RD columns shows up as below.



But after we select the column, click on OK and then try to save the section, the below errors gets thrown.



Pasting errors below for easier reading

I have sourced a Dropdown using a RD.  In the RD, one of the fileds uses the concatenate function. When the RD is run standalone it runs fine and returns the expected data.

If I try to use the concatenated RD property in the Dropdown, Pega throws errors and is NOT allowing to configure the concatenated property on the dropdown.

Below is the RD output.

In the dropdown control in the section, the RD columns shows up as below.

But after we select the column, click on OK and then try to save the section, the below errors gets thrown.

Pasting errors below for easier reading

Test compilation failed: ---------- 
1. ERROR in Rule_HTML_Section_XXXX_SeverityCodes_Stream_20161220T070942_347_GMT.java (at line 493) 
   tools.appendString(pega_uiengine_formatter.pxFormatText(pega_uiengine_pzcontrol.pzGetCaptionValue("reportdefinition","XXXX-SeverityCode","GetSeverityCode:$","","","",".@@pxConcatenate(.SEVERITY_CODE,.SEVERITY_DESC,"-")",".SEVERITY_CODE",false,(PegaStreamAPI)tools),false,"","",false,"caption")); 
    ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ 
The operator - is undefined for the argument type(s) java.lang.String, java.lang.String 
---------- 
2. ERROR in Rule_HTML_Section_XXXX_SeverityCodes_Stream_20161220T070942_347_GMT.java (at line 494) 
    if("".equals(pega_uiengine_pzcontrol.pzGetCaptionValue("reportdefinition","XXXX-SeverityCode","GetSeverityCode:$","","","",".@@pxConcatenate(.SEVERITY_CODE,.SEVERITY_DESC,"-")",".SEVERITY_CODE",false,(PegaStreamAPI)tools)) && pzAuto.getBrowserUtils().isIE() && !pega_uiengine_harness.pzInStandardsMode()){ 
    ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ 
The operator - is undefined for the argument type(s) java.lang.String, java.lang.String 
---------- 
3. ERROR in Rule_HTML_Section_XXXX_SeverityCodes_Stream_20161220T070942_347_GMT.java (at line 580) 
    displayString = cbpRow.getStringIfPresent(".@@pxConcatenate(.SEVERITY_CODE,.SEVERITY_DESC,"-")"); 
    ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ 
The operator - is undefined for the argument type(s) java.lang.String, java.lang.String 
---------- 
3 problems (3 errors)

***Updated by moderator Maryrita: Moved to Product Support from Upgrade Center***

Reporting User Experience
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.